Home > IT Answers > Microsoft Windows > Excel conditional formula
Johnaldo
160 pts.
 Excel conditional formula
Microsoft Excel, Microsoft Excel formulas
Hi all, I can write a basic conditional formula such as =IF(A1="23", "OK", "NOT OK"), but I want to add a supplementary condition ... For example if A1 is 23 and B1is 24 then the cell will display OK or NOT OK as appropriate... both conditions need to be met. TIA, John

Software/Hardware used:
MS Excel 2003
ASKED: February 1, 2013  8:46 AM
UPDATED: February 1, 2013  12:59 PM
RELATED QUESTIONS
 
  Help
 Approved Answer - Chosen by Johnaldo (Question Asker)

In relation to jailaa101 answer, the question really needs part 2 of given answer dealing with AND/Or logic in IF statements. Go tohttp://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/

ANSWERED:  Feb 1, 2013  10:15 PM (GMT)  by Johnaldo
 
Other Answers:

That did the job – thanks.

 

I used

=IF(AND(A1=”Y”, B1=”Y”),”ü”, “”)

… if 2 cells are positive, then I get a tick symbol in the parent cell, otherwise nothing.

 

Cheers, Johnaldo

Last Wiki Answer Submitted:  February 5, 2013  12:03 am  by  Michael Tidmarsh   14,000 pts.
Latest Answer Wiki Contributors:  Johnaldo   160 pts. , TomLiotta   110,135 pts. , jailall101   735 pts. , Michael Tidmarsh   14,000 pts.
To see other answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _