View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franksta
 
Posts: n/a
Default '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.