Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Round Down
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. Is there any way that I can combine these formula's into cell X73 so that I do not have to have column Y? I have tried inserting + between the two and also tried AND but neither works. I am actually using Planmaker for this spread sheet but it is almost the same as Excel, or so I am told. I should mention that I am a 79 year old spread sheet newbie so please be gentle with me! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round Up and Round Down Time | Excel Worksheet Functions | |||
Round up to next .5 | Excel Worksheet Functions | |||
VB Function Round vs Excel function Round not behaving the same Od | Excel Programming | |||
Round up | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |