Thread
:
If/Then
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
bj
external usenet poster
Posts: 1,397
If/Then
=if(A1="X","NO",IF(OR(AND(L2=7,L2<=100),AND(M2=1 ,M2<=100)),"YES",""))
"nabanco" wrote:
Hello,
How would I change the below formula to say "NO" if row A had an "X" placed
in that cell.
=IF(OR(AND(L2=7,L2<=100),AND(M2=1,M2<=100)),"YES ","")
Reply With Quote
bj
View Public Profile
Find all posts by bj