Using ROUNDDOWN - Help please

  • Thread starter Thread starter BritRaider
  • Start date Start date
B

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.
 
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))
 
Many thanks David - I knew that (like me) it had to be simple ;-)

--
-=<BritRaider>=-


David Biddulph said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top