Formula Entry

  • Thread starter Thread starter Susi
  • Start date Start date
S

Susi

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
 
I believe this will work for you.

=IF(($I14-$A14)<0,ROUNDDOWN(IMABS($I14-$A14)*0.8),""))

Les
 
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),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs 2
Zero and Null Sum Function 2
Searching the formula (not the value) for a text string 1
Using time functions to give a warning 6
Testing for conditions with IF statement and AND function 1
Trouble constructing IF statement 1
Wow, never seen this error before (Excel science experiment) 3
Express Hours in Days Q 2

Back
Top