'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
 

Hi, your question doesn't have enough information in it. If I understand what
you could be doing, what you can do is inbed if statements as follows:

=if(b30,c3,if(d30,e3,"nothing"))

That way you can reference multiple circumstances. Maybe this will help.