Excel formula chahiye

**alim khan** · 5th June 2010, 11:56 AM

FREINDS MUJHE EK EXCEL KA FORMULA CHAHIYE.

AGAR A ROW MEIN 25.9875 PAISA HAI TO B ROW MEIN FORMULA LIKHNE PER WOH 26 HOJAYE
MASLAN 25.49 HO TO 25(0.49 KE NICHE JO BHI HO WOH 0 AUR 0.49 KE UPER JO BHI HO WOH 1) AUR 25.5 HO TO 26 HO JAE.

34.41375 =34

38.475 =38

36.871875=37

**sajjad_abid60** · 5th June 2010, 12:14 PM

alim khan said:

FREINDS MUJHE EK EXCEL KA FORMULA CHAHIYE.

AGAR A ROW MEIN 25.9875 PAISA HAI TO B ROW MEIN FORMULA LIKHNE PER WOH 26 HOJAYE
MASLAN 25.49 HO TO 25(0.49 KE NICHE JO BHI HO WOH 0 AUR 0.49 KE UPER JO BHI HO WOH 1) AUR 25.5 HO TO 26 HO JAE.

34.41375 =34

38.475 =38

36.871875=37

ya lo bhai aysay lagay ga formula sheet or picture dekho

**alim khan** · 5th June 2010, 12:29 PM

sajjad_abid60 said:

ya lo bhai aysay lagay ga formula sheet or picture dekho

bohot bohot shukriay bhai.

**zeest** · 5th June 2010, 12:44 PM

yaar ye excel k ander he right click kar k format cells per jao or udher number ki tab mai accounting mai jaa kar setting karo... wahan accounting k under "0" kar do to sub set ho jay ga...