=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,'J L&AH'!E24)))

How can I make this work?

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

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Bill R" wrote:

=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,'J L&AH'!E24)))

How can I make this work?

Try this

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


--

HTH

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


"Bill R" wrote in message
...
=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,'J L&AH'!E24)))

How can I make this work?