| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Entry
How can I get this formula to return a Rounded Down to an Whole Number?
=IF(($I14-$A14)<0,IMABS($I14-$A14)*0.8,"") Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Entry
I believe this will work for you.
=IF(($I14-$A14)<0,ROUNDDOWN(IMABS($I14-$A14)*0.8),"")) Les "Susi" wrote: How can I get this formula to return a Rounded Down to an Whole Number? =IF(($I14-$A14)<0,IMABS($I14-$A14)*0.8,"") Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Entry
Thank you, I just had to add the zero at the end to round it down to 0
places and it worked! Susi =IF(($I14-$A14)<0,ROUNDDOWN(IMABS($I14-$A14)*0.8,0),"") "WLMPilot" wrote: I believe this will work for you. =IF(($I14-$A14)<0,ROUNDDOWN(IMABS($I14-$A14)*0.8),"")) Les "Susi" wrote: How can I get this formula to return a Rounded Down to an Whole Number? =IF(($I14-$A14)<0,IMABS($I14-$A14)*0.8,"") Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to repeat the upper row formula without entry formula? | Excel Discussion (Misc queries) | |||
| Prevent formula entry | Excel Worksheet Functions | |||
| Formula doesn't find last entry | Excel Discussion (Misc queries) | |||
| Formula for duplicate entry | Excel Worksheet Functions | |||
| Daily entry formula | Excel Discussion (Misc queries) | |||
Linear Mode
