If function referring to a merged cell in another worksheet

Steve'n Ayr · May 26th, 2002, 12:14 PM

I am try to enter an if function formula that will refer to a merged cell in another worksheet. The merged cell contains a drop down menu created via Data/Validation/List. The if function returns a false value when it should return a true value.
The formula I am using is
=if('initial interview'!f84="Strain/Sprain/Inflammation/Tendonitis",1,4)
After selecting Strain/Sprain/Inflammation/Tendonitis from the drop down list the if formula still returns a false result.
Can anyone help

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

May 26th, 2002, 12:14 PM	#1
Steve'n Ayr Join Date: May 2002 Posts: 14	I am try to enter an if function formula that will refer to a merged cell in another worksheet. The merged cell contains a drop down menu created via Data/Validation/List. The if function returns a false value when it should return a true value. The formula I am using is =if('initial interview'!f84="Strain/Sprain/Inflammation/Tendonitis",1,4) After selecting Strain/Sprain/Inflammation/Tendonitis from the drop down list the if formula still returns a false result. Can anyone help Thanks