=IF(A1=5, "green apple","red apple")
Add to this new condition:
=IF(A2=5,"green apple","red apple")
Basically if A1 and A2 = 5 then "green apple", otherwise "red apple".
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community