Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-30-2017, 09:18 AM
bksmith bksmith is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2017
Posts: 4
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
  #2  
Old 06-30-2017, 10:06 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
A Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 121
NBVC is on a distinguished road
Default

Try:

=IF(E8-8<=0,0,E8-8)

or

=MAX(0,E8-8)
Reply With Quote
  #3  
Old 07-18-2017, 09:53 AM
bksmith bksmith is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2017
Posts: 4
bksmith is on a distinguished road
Default

thank you, that did the trick!
Reply With Quote
Reply

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


All times are GMT -7. The time now is 06:46 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft