Using ROUNDDOWN - Help please

[BritRaider]

I WANT my formula to say:-

If a5 is blank, leave this field blank, otherwise multiply a6 by a7 and
round the answer DOWN to 2 decimal places - but I can't get it to work.

I tried:-

=If(a5="","",rounddown(a6*a7),2)

Removing "rounddown" and ",2" makes the formula work (but with too many
decimal places). So what am I doing wrong with the rounddown part??

Many thanks in advance.

 

[David Biddulph]

What you are doing wrong with the rounddown part is forgetting that it needs
the second argument to be inside the parentheses.
[Similarly the IF wants only 3 arguments, not the 4 you've given it.]

Try =If(a5="","",rounddown(a6*a7,2))

 

[BritRaider]

Many thanks David - I knew that (like me) it had to be simple ;-)

--
-=<BritRaider>=-

What you are doing wrong with the rounddown part is forgetting that it
needs the second argument to be inside the parentheses.
[Similarly the IF wants only 3 arguments, not the 4 you've given it.]

Try =If(a5="","",rounddown(a6*a7,2))
--
David Biddulph

I WANT my formula to say:-

If a5 is blank, leave this field blank, otherwise multiply a6 by a7 and
round the answer DOWN to 2 decimal places - but I can't get it to work.

I tried:-

=If(a5="","",rounddown(a6*a7),2)

Removing "rounddown" and ",2" makes the formula work (but with too many
decimal places). So what am I doing wrong with the rounddown part??

Many thanks in advance.

 

[Gord Dibben]

Get rid of the ")"

=IF(A5="","",ROUNDDOWN(A6*A7,2))


Gord Dibben MS Excel MVP