|
|
#1
06-30-2017, 09:18 AM
|
|||
|
|||
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement | Gwilson | Excel | 3 | 04-13-2017 11:31 AM |
| Help! figuring if statement with 2 vlookups excel 2013 | MWATKINS7111 | Excel | 3 | 02-24-2017 12:58 AM |
 Need a little help with an if statement
|
cangelis | Excel | 2 | 04-08-2015 05:55 PM |
|
Mail merge will not format date field generated by Excel IF statement
|
borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
|
Help with IF Statement
|
limpbizkit | Excel | 4 | 02-24-2011 09:16 PM |
Windows 10 
Office 2016
Threaded Mode