To Create A Commission Report Microsoft Excel XP

To Create A Commission Report (Kwgkb wi‡cvU© ‰Zix Kiv) t

E2 Cell G Mouse Pointer ‡i‡L:

=IF(D2<15000,D2*6%,IF(D2<30000,D2*12%,IF(D2<50000,D2*20%,IF(D2<75000,D2*25%,IF(D2>=75000,D2*30%)))))

D³ m~ÎwU cÖ‡qvM Kiv n‡q †M‡j Enter Press Ki“b| AvkvKwi djvdj †c‡q †M‡Qb| wK k‡Z©i Dci wfwË K‡i m~ÎwU

cÖ‡qvM K‡i‡Qb Zv eyS‡Z †c‡i‡Qb e‡j Avgvi wek¦vm| †Kvb mgm¨v _vK‡j wk¶‡Ki mnvqZvq mgvavb Ki“b|