Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-30-2017, 09:18 AM
bksmith bksmith is offline EXCEL IF STATEMENT Help Windows 10 EXCEL IF STATEMENT Help Office 2016
Novice
EXCEL IF STATEMENT Help
 
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
  #2  
Old 06-30-2017, 10:06 AM
NBVC's Avatar
NBVC NBVC is offline EXCEL IF STATEMENT Help Windows 10 EXCEL IF STATEMENT Help Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
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 EXCEL IF STATEMENT Help Windows 10 EXCEL IF STATEMENT Help Office 2016
Novice
EXCEL IF STATEMENT Help
 
Join Date: Jun 2017
Posts: 5
bksmith is on a distinguished road
Default

thank you, that did the trick!
Reply With Quote
  #4  
Old 07-27-2021, 07:01 AM
zacharyswift829 zacharyswift829 is offline EXCEL IF STATEMENT Help Windows 10 EXCEL IF STATEMENT Help Office 2016
Novice
 
Join Date: Jul 2021
Posts: 1
zacharyswift829 is on a distinguished road
Default

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
Reply With Quote
Reply



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
EXCEL IF STATEMENT Help Need a little help with an if statement cangelis Excel 2 04-08-2015 05:55 PM
EXCEL IF STATEMENT Help Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
EXCEL IF STATEMENT Help Help with IF Statement limpbizkit Excel 4 02-24-2011 09:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft