Solved Need blank cell if 0 value

May 6, 2015 at 09:22:00
Specs: Windows 7
=ROUND(IF(B5>0,4.285714285*$D2,""), 1)
This is my formula - if B5 is blank, #VALUE! shows in the cell.

See More: Need blank cell if 0 value

Report •


#1
May 6, 2015 at 09:39:18
✔ Best Answer
I solved my own problem: =ROUND(IF(B5>0,4.285714285*$D2,0), 1)

Changed the "" to 0


Report •

#2
May 6, 2015 at 10:21:53
Good work, glad you found your answer.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question