Solved How do I round down the results of true/false parts IF stmt

March 14, 2017 at 14:48:00
Specs: Windows 64
How do I round down the result of the true and false parts of an if statement...

=(IF(B13=0,B20/8,B20/4))


See More: How do I round down the results of true/false parts IF stmt

Reply ↓  Report •

#1
March 14, 2017 at 16:17:48
✔ Best Answer
First, you don't need the parenthesis around the entire IF.

=IF(B13=0,B20/8,B20/4)

As for your question, simply use the ROUNDOWN function in your value_if_true and value_if_false arguments, just like you would use them in a cell.

=IF(B13=0,ROUNDDOWN(B20/8,1),ROUNDDOWN(B20/4,1))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •
Related Solutions


Ask Question