MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Not sure what to call it

Posted by Heriberto Latigo on September 25, 2001 1:03 PM

Im trying to do a form of an IF formula, however, I think there more needed. What I am trying to find out is, If for example Col "C" Row "1", meets a certain criteria..lets say <1. Then take the name within Col "A" and place it in this cell. ALSO!!! If the value thats tied to Col "A" row "1"...lets say its in Col "B" and is over a certain limit then for the cell (or some cell) to say Exceed limits.

As you can see, this is a multiple step problem and I am lost. I welcome anyones help and I will be very much appreciated.

Posted by Lance A. Miller on September 25, 2001 1:11 PM

Did you try a CSE? Mr. Excel has a page somewhere on the site that explains CSE. It allows you to enter multiple If,then statements into one formula. The catch is, instead of hitting enter when you are done, you must hold down Control+Shift and hit enter.
Hope this helps.

Posted by IML on September 25, 2001 1:12 PM

Not real sure, but you could try
=IF(AND(C1<1,B1<=50),A1,"Exceeds limits")
This will return the value of A1 if C1 is less than 1 and B1 is not over 50.

good luck