IF two different conditions are met

  • Thread starter Thread starter AnnaV
  • Start date Start date
A

AnnaV

It doesn't seem to be working. I want to use a range of cells so my
formula is:
=IF('Gov''t Orders'!A2:A37=254,IF('Gov''t Orders'!B2:B37="Jeff
Mott",'Gov''t Orders'!C2:C37,0),0)

Is it still going to work?
 
I would get rid of the punctuation in the sheet name to start. It cannot be
helping!
 
If the formula ='Gov"t Orders'!A2:A37 is put in the same sheet it will return
a value based on the position in the range, i.e. the value in cell A2 will be
returned if the formula is in D2. If the formula is in another sheet it will
return an error. What are your trying to achieve with the formula?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF 4
Excel VBA 1
Input sheet with INDEX formula 4
Date Formula with 2 conditions met needed 5
Conditional Formatting Applying Rule to Entire Column 2
conditional formatting 4
conditional formatting in excel 2007 1
enter value if 2 criteria are met 5

Back
Top