Could someone please help me with this--
I need a formula that does the following:
If either cell A1 or B1 has a value >.94, then I want C1 to show the text "yes". If both A1 and B1 are >.94, then I also want C1 to show the text "yes". If neither A1 nor B1 has
a value >.94 (that is, if both A1 and B1 are <.94), then I want C1 to show the text "no".
Thank you.
Lorbiculous
Hi Lorbiculous..
In C1 try this..
Formula:
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Another slight variation...
=IF(or(A1>0.94,B1>0.94),"Yes","No")
Debraj's formula is really good, I just wanted to show how to use the OR() function in this situation
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Debraj Roy,
Thanks for your response. The formula worked for cases where both A1 and B1 were >0.94, but not for cases when only one of those cells was >0.94. The OR formula worked when either cell or both cells were >0.94. I'm not sure how clearly I explained the problem.
Thank you again for replying.
Lorbiculous
I think you want MAX instead of MIN...Originally Posted by Debraj Roy
Formula:Please Login or Register to view this content.
=IF(OR(OR(A1>0.94,B1>0.94),AND(A1>0.94;B1>0.94)),"Yes","No")
THanks, I will try that since MIN didn't work. I used an IF and OR formula suggested by another contributor, which worked, but I like to have different options.
=IF(MIN(A1:B1)>0.94,"Yes","No")
Change it in
=IF(MAX(A1:B1)>0.94,"Yes","No")
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks