Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Nested IF Statements
Thank you all for your help. I finally figured it out! This is my final product/formula: =IF((F7<=2.0049),25,IF(('CPM 3 Yr. Compare'!M6<='CPM 3 Yr. Compare'!L6),(LOOKUP('Cons Comments 2007 vs...- asoto6
- Post #6
- Forum: Microsoft: Office
-
Nested IF Statements
Yogia: Thank you, but it won't do it. I have tried. Any other thoughts?- asoto6
- Post #5
- Forum: Microsoft: Office
-
Nested IF Statements
bluedragon2: Thanks for the tip, but it does not quite work. I see/understand your logic (I had tried this before) but yet it does not return with correct result.- asoto6
- Post #3
- Forum: Microsoft: Office
-
Nested IF Statements
Need help with this formula. I would like to add another condition to this formula (see below). The condition is: =IF(F6<=2.0049,25, that is if a certain number is greater than or equal to 2.0049, allocate 25 points, if not then continue with formula below. =IF('CPM 3 Yr. Compare'!M8<='CPM 3...- asoto6
- Thread
- Replies: 7
- Forum: Microsoft: Office
