USING NAMES IN FORMULAS

[Bill R]

=IF(ISBLANK(BA6),"",(IF(ISBLANK(Q24),'SL&AH'!E24,'JL&AH'!E24)))

The formula above is what I have been using and it works perfectly, but I
want to change it to give the first value if "Single" is typed in the cell
(Q24) but if "Joint" is typed in the cell (Q24) then the 2nd value would be
returned.

This is what I tried but it returns a name error:

=IF(ISBLANK(BA6),"",(IF(Q24=Single),'SL&AH'!E24,'JL&AH'!E24)))

How can I make this work?

 

[Gary L Brown]

=IF(ISBLANK(BA6),"",(IF(Q24="Single"),'SL&AH'!E24,'JL&AH'!E24)))
HTH,

 

[Bob Phillips]

Try this

=IF(ISBLANK(BA6),"",IF(Q24="Single",'SL&AH'!E24,'JL&AH'!E24))


--

HTH

RP
(remove nothere from the email address if mailing direct)