I am trying to write a single statement in a single cell that looks at two cells for thresholds.
if cell 1 >= 150 AND cell 2 >=150 then "soft cap"
if cell 1 >= 167 AND cell 2 >=100 then "soft cap"
if cell 1 >= 200 AND cell 2 >=150 then "hard cap"
if cell 1 >= 233 AND cell 2 >=100 then "hard cap"
Appreciate any insights/help in solving this.
Try
=IF(OR(AND(A1>=233,B1>=100),AND(A1>=200,B1>=150)),"hard",IF(OR(AND(A1>=167,B1>=100),AND(A1>=150,B1>=150)),"soft"))&" cap"
where A1 is cell 1
B1 is cell 2
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
This worked perfectly - THANK YOU! one additional question: when the statement is false right now it shows "false cap"....I would like that to just be blank. Where do I insert the "" for the false statement?
try
=IF(OR(AND(A1>=233,B1>=100),AND(A1>=200,B1>=150)),"hard cap",IF(OR(AND(A1>=167,B1>=100),AND(A1>=150,B1>=150)),"soft cap",""))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Bingo! Thank you nflsales!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks