Posted to microsoft.public.excel.programming

fentonas1

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Constants	Roger	Excel Programming	2	July 24th 09 06:32 PM
Excel sees cell formulas as constants, will not solve	Derek P	Excel Worksheet Functions	1	July 28th 06 04:16 PM
Finding constants in formulas	Co-op Bank	Excel Programming	13	November 3rd 05 04:36 PM
Finding constants in formulas	Co-op Bank	Excel Worksheet Functions	1	October 27th 05 02:09 PM
Finding constants in formulas	Co-op Bank	Excel Discussion (Misc queries)	1	October 27th 05 11:33 AM

All times are GMT +1. The time now is 04:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us