formulas containing constants
Not exactly clear what you mean by constant, but I will guess that you need
=IF(OR(B2=$G$2,B2=$G$3,B2=$G$4,B2=$G$5),"Already set up","Not set up")
so that the row number does not change when you copy the formula.
Tom
"fentonas1" wrote:
Hi, it's been a long time since I have worked with formulas and I am having
problem with a formula that is working with constants. My formula is:
=IF(OR(B2=$G2,B2=$G3,B2=$G4,B2=$G5),"Already set up","Not set up")
G2 through G5 should remain constant. What am I doing wrong?
--
Kelly
|