Previous Topic Next Topic

Excel function

Closed
Dan - 28 Feb 2010 à 12:36
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 28 Feb 2010 à 12:49
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.
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
28 Feb 2010 à 12:49
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)