View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fentonas1 fentonas1 is offline
external usenet poster
 
Posts: 1
Default formulas containing constants

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