You didn't say what you wanted if G2>= 10. Put that where the ??? is.
=IF(OR($H2="Yes", AND(OR($B2="Clean", $B2="clean2"),$C2="floor", $G2>=5)),IF($G2<10, "Alert", ???),"")
Does that work for you?
You didn't say what you wanted if G2>= 10. Put that where the ??? is.
=IF(OR($H2="Yes", AND(OR($B2="Clean", $B2="clean2"),$C2="floor", $G2>=5)),IF($G2<10, "Alert", ???),"")
Does that work for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks