Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2015, 04:55 AM
cangelis cangelis is offline Need a little help with an if statement Windows 7 64bit Need a little help with an if statement Office 2010 64bit
Novice
Need a little help with an if statement
 
Join Date: Jan 2014
Posts: 18
cangelis is on a distinguished road
Default Need a little help with an if statement

I have a very basic formula that I use on a report. It is E5-AI9. However, I need the formula to read:



If E5 is greater than 9494, then results in AI9 should be 0. I know this should be a pretty basic question.

Thank you.
Reply With Quote
  #2  
Old 04-07-2015, 05:12 AM
cangelis cangelis is offline Need a little help with an if statement Windows 7 64bit Need a little help with an if statement Office 2010 64bit
Novice
Need a little help with an if statement
 
Join Date: Jan 2014
Posts: 18
cangelis is on a distinguished road
Default

Sorry - my error. The if statement should be:

if the current column is greater than 9494 then the result should be zero. Oftentimes my total is higher than the 9494 and I end up with a negative percentage. I should not have a negative percentage.
Reply With Quote
  #3  
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

Thread Tools
Display Modes


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 10:56 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