View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BritRaider BritRaider is offline
external usenet poster
 
Posts: 2
Default Using ROUNDDOWN - Help please

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