View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
TomPl TomPl is offline
external usenet poster
 
Posts: 342
Default 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