23 July 2008

Excel formula....to roundown the number....

The number will appear like this when 1 x 2.5  will appear 2.5 ringht?

So we don't want the decimal and it will appear 3. Right?

But i don't want to round up i wanted the number to be round down!!!

So the anwer appear to 2 not 3. Emmm, so what i should do and i have to include in excel sheet.

And this for future use too...............ketap gigi, geram2 x dapat and then keep googling,

memula xtahu search apa,

just keep googling and then jeng2.....so nak tahu ke formula dia macam mana?



=ROUNDDOWN(number,digit)



Tapi nak include include total so the formula should be like this



=ROUNDDOWN(SUM(CELLy*CELLx),0)



Another contoh like this spreadsheets created by me:





But please enter the SUM value dahulu and then modify later, kalau terus letak formula tue semua terus memang x jadi. k!



 Just for ur info!!!!

No comments:

Post a Comment