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

"BritRaider" wrote in message
...
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.