Thread: Round Down
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Round Down

Hi,

Am Fri, 16 Aug 2013 09:14:34 +0100 schrieb Quilp:

I have this formula in cell X73: =IF(A73="","",U73-(C73*2.433)) which
returns the value 39.58.
In cell Y73 I have this formula: =ROUNDDOWN(X73,0) which returns the
value 39.


try:
=IF(A73="","",ROUNDDOWN(U73-C73*2.433,0))
or
=IF(A73="","",INT(U73-C73*2.433))


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2