#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Try:
=IF(E8-8<=0,0,E8-8) or =MAX(0,E8-8) |
#3
|
|||
|
|||
thank you, that did the trick!
|
#4
|
|||
|
|||
There are various types of these statements you can use depending on the criteria for testing a condition, as well as when you want the test to be conducted. Here's a quick overview of some of them and their syntax:
=IF(A1="Yes", "Hello World","Hello Universe") - evaluates A1 for "yes" and displays "hello world" if it does so =IF(A1="No", "<math>FINAL VALUE</math>","<math>SUPER DUP To learn how to make an IF statement and to download the resource, please visit: Excel IF Function – How to Use |
|
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 |