Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-08-2015, 05:55 PM
BudVitoff BudVitoff is offline Need a little help with an if statement Windows 7 64bit Need a little help with an if statement Office 2007
Advanced Beginner
 
Join Date: Sep 2011
Posts: 52
BudVitoff is on a distinguished road
Default


The basic formula that you want to use is =if (x,t,f) which reads "if the value of x is true, then this cell (that contains this formula) will be set to the value of t, otherwise it will be set to the value of f."

So to use your cell names of E5 and AI9, your result cell could read =if((E5-AI9)>9494,0,(E5-AI9)). This is the most concise and self-explanatory form.

Some people might be bothered by the fact that the subtraction may be performed twice, so they'll take two steps: first to subtract and put the difference in a temporary cell, then to have the result cell look at the temporary cell. I wouldn't bother. (I hesitate to mention that the result cell could actually be used as the temporary cell, but Excel will spit up and give you a warning about doing stuff like that. Don't do it.)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a statement sma Word 6 03-23-2014 10:30 AM
Need a little help with an if statement Need help with If, Then Statement Please cangelis Excel 4 01-03-2014 09:10 AM
Need a little help with an if statement Help with IF Statement limpbizkit Excel 4 02-24-2011 09:16 PM
Need a little help with an if statement if statement piper7971 PowerPoint 1 08-19-2010 07:10 AM
Need a little help with an if statement Help with IF statement! CPelkey Word 1 04-12-2010 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:08 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