IF two different conditions are met

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?
 
B

Bernard Liengme

I would get rid of the punctuation in the sheet name to start. It cannot be
helping!
 
G

Gary Rowe

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?
 
Top