#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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.) |
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 help with If, Then Statement Please | cangelis | Excel | 4 | 01-03-2014 09:10 AM |
Help with IF Statement | limpbizkit | Excel | 4 | 02-24-2011 09:16 PM |
if statement | piper7971 | PowerPoint | 1 | 08-19-2010 07:10 AM |
Help with IF statement! | CPelkey | Word | 1 | 04-12-2010 09:06 AM |