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