Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I use 'And' or "Or" in an If statment
Want to compare if cell 1 = "UP" AND cell 20 are true, then say OK, if cell
1="up" and cell 2 <0,then say "Bad", other wise say "Wrong" |
#2
|
|||
|
|||
wmurphyjr, try this,
=IF(AND(A1="up",A20),"OK",IF(AND(A1="up",A2<0),"B ad","Wrong")) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "wmurphyjr" wrote in message ... Want to compare if cell 1 = "UP" AND cell 20 are true, then say OK, if cell 1="up" and cell 2 <0,then say "Bad", other wise say "Wrong" |
#3
|
|||
|
|||
Murphy
When the case is important like here, you can use EXACT() as in: =IF(AND(EXACT(A1,"UP"),B10),"OK",IF(AND(EXACT(A1, "up"),B1<0),"Bad","Wrong")) -- Best Regards Leo Heuser Followup to newsgroup only please. "wmurphyjr" skrev i en meddelelse ... Want to compare if cell 1 = "UP" AND cell 20 are true, then say OK, if cell 1="up" and cell 2 <0,then say "Bad", other wise say "Wrong" |
#4
|
|||
|
|||
Leo, I missed the upper and lower "up", thanks for the catch
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Leo Heuser" wrote in message ... Murphy When the case is important like here, you can use EXACT() as in: =IF(AND(EXACT(A1,"UP"),B10),"OK",IF(AND(EXACT(A1, "up"),B1<0),"Bad","Wrong") ) -- Best Regards Leo Heuser Followup to newsgroup only please. "wmurphyjr" skrev i en meddelelse ... Want to compare if cell 1 = "UP" AND cell 20 are true, then say OK, if cell 1="up" and cell 2 <0,then say "Bad", other wise say "Wrong" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|