Multiple "IF"'s
Solar Man wrote:
I thought I had this one licked. I have a list of TRUE FALSE cells. There
are 18 of them. Say they were listed A1:A9 and B1:B9 then if A! is TRUE,
insert contents of C1. If A6 is TRUE, insert contents of C6 and so on. Only
one of them will be TRUE at any time. I tried using multiple IF's but found
I could only enter 6 and then it wouldn't take any more. Is there a better
way to do this? Thank you in advance.
Could you use
=IF(OR(A1,B1),C1,"")
?
|