Previous Topic Next Topic

Excel function

Closed
Dan - Feb 28, 2010 at 12:36 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 28, 2010 at 12:49 PM
Hello,
I am trying to look into 2 different cells for certain data and if it is true than put something in a third cell.
For example: if C2 has an "X" in it and H2 ">0" then I want to put "check log" into cell M2. I think I'm close to getting it but not quite there. I was trying to use an IF or IFS statement but believe it only works for two cells but not sure. Any help would be appreciated. Thank you.

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 28, 2010 at 12:49 PM
Now it can work for two cells and more. Only catch is you cannot have more than 7 nested if

and for you, only one is req

=if (AND(condition 1, condition 2), true action, false action)
0