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.

--
-=<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

"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.

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

--
-=<BritRaider=-


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.

Get rid of the ")"

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


Gord Dibben MS Excel MVP

On Tue, 21 Aug 2007 14:49:55 GMT, "BritRaider" wrote:

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.