Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 06:23 AM.


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