EXCEL IF STATEMENT Help
How do I get an IF Statement to display the value if conditions are met?
=IF(E8-8<=0,"0") With this, I am able to get part of my desired result. If the value entered into cell E8 is 8 or less, it displays 0 in the cell. What I would like to have happen is when the value of E8-8 is greater than 0, I want it to display the difference.
E8=12-8 would leave a value of 4. This is what I want to display in the cell.
or E8=15-8 would leave a value of 7...
The value entered in E8 could be anything from 0 to 24.
|