To Create A Electric Bill Microsoft Excel XP

To Create A Electric Bill (we`y¨r wej ‰Zix Kiv) t

we`y¨r wej ˆZix Kivi c~‡e© Company KZ„©K cÖ`Ë kZ©¸‡jv †R‡b wb‡Z n‡e| hw` kZ©¸‡jv GiKg nq †h, MÖvnK 120

BDwb‡Ui wb‡P LiP Ki‡j Zvi wej n‡e 1.2 UvKv nv‡i| 210 BDwb‡Ui wb‡P LiP Ki‡j Zvi wej n‡e 1.75 UvKv nv‡i| 350

BDwb‡Ui wb‡P LiP Ki‡j Zvi wej n‡e 2.1 UvKv nv‡i| 500 BDwb‡Ui wb‡P LiP Ki‡j Zvi wej n‡e 2.7 UvKv nv‡i| Ges

MÖvnK 500 BDwb‡Ui ‡ekx hZB LiP †nvK bv ‡Kb Zvi wej n‡e 3.1 UvKv nv‡i| Dc‡iv³ kZ©mv‡c‡¶ A‡bK MÖvn‡Ki †gvU

we`y¨r wej ˆZix Kivi Rb¨ wb‡Pi QK I m~Î e¨envi Ki“b| Cell No, Total Unit, Unit Price, Etc cwieZ©b †hvM¨|

cÖ‡qvR‡b wk¶‡Ki wbKU †_‡K cÖkoevbymv‡i m~‡Îi cÖ‡qvM ey‡S wbb|

E2 Cell G Mouse Pointer ‡i‡L:

=IF(D2<120,D2*1.2,IF(D2<210,D2*1.75,IF(D2<350,D2*2.1,IF(D2<500,D2*2.7,IF(D2>500,D2*3.1)))))

D³ m~ÎwU cÖ‡qvM Kiv n‡q †M‡j Enter Press Ki“b| AvkvKwi djvdj ‡c‡q †M‡Qb| Gevi Formula Copy Ki“b|

wbðqB mevi djvdj †c‡q‡Qb| Gfv‡eB A‡bK MÖvn‡Ki we`y¨r wej ˆZix Kiv hvq|