Excel help

I currently have this formula
=IF(F6=0,"",SUM(((G6*0.1299)+(0.147*31))*0.94)*-1)
Currently give the value 40.92 as have it set for two decimal places it would be 40.9154 if set to four.
What I want is for the formula to round down to two decimal places, so this value would read 40.91

Any way to do it?

From very distant memory what you need to do is subtract 0.005 (i.e. half the next significant digit) then use the roundup command, or let Excel round for you.

Edited by deleted (Sun 03-Feb-13 23:19:21)

Or use the FLOOR fn.

Use the rounddown function

At its simpleness using A1 as the cell for 40.9154 =rounddown(A1, 2) would give you 40.91. Though you could nest the rounddown function in your formula, if you do not want the answer in a separate cell.

Thanks for the reply, and others too.

It's the nesting in the formula that I'm having trouble with.

I can do it in another cell but want to try and avoid that,
Having the "IF" in the formula is throwing me.

Try =IF(F6=0,"",ROUNDDOWN(SUM((((G6*0.1299)+(0.147*31))*0.94)*-1),2))

Thanks Mikey, worked a treat.

Or you could format the result cell to two decimal places.

In reply to a post by camieabz:

Or you could format the result cell to two decimal places.

That's what I had set, but it was rounding up.

Hmm. Isn't that the point in such cases?

(Not arguing, just curious )