Cell dependent on another

J

jhicsupt

Need help with an If statement which refers to different sheets.

In Cell B2 is where I want the value returned
If Sheet1 B4 not equal to "pens", put "Not applicable" in cell B2
Otherwise, put the value of Sheet3 C12 in cell B2

Can I get help with this formula?

Thanks in advance
 
R

Richard Neville

Try this: =IF(B4="pens",[contents of Sheet 3 C12],"Not applicable"). The
trick is that you can't use a "not equal to" value in an IF statement, so
you have to turn it around so the first IF possibility is positive (E6
equals "pens"), the second negative.
 
Top