View Single Post
 
Old 06-30-2017, 09:18 AM
bksmith bksmith is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2017
Posts: 5
bksmith is on a distinguished road
Default 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.
Reply With Quote