PDA

View Full Version : IF STATMENT



Tenspeed39355
02-02-2006, 10:58 AM
Hi guys I have lost some of my statements for excel.
I need the IF statement.
Here is what I am doing. I have a number in O3. What I want to do with the IF
Statements is IF O3 >70 the result is "Over" IF the result is < 30 the result is
"Under" Any other numbers will be "". I had all the formulas so I could grab them
quickly but for some reason I can not find the IF statement. Thanks for the help
Max:hi:

Jacob Hilderbrand
02-02-2006, 11:38 AM
Here you go.

=IF(O3>70,"Over",IF(O3<30,"Under",""))

Tenspeed39355
02-02-2006, 12:36 PM
Great job Jake. I was soooooo close. Again thanks for you time with this
Max

Jacob Hilderbrand
02-02-2006, 01:30 PM
You're Welcome :beerchug:

Take Care