Toggle Button
 

Hi,
I am constructing a spreadsheet, which has several ToggleButtons.

Everything is working fine, except for the one toggle button, which has
its TripleState, set to be TRUE.

The offending formula (of which, the final argument is troublesome),
appears below.

IF(A1=TRUE,"The Maximum Amount",IF(A1=FALSE,"The Median
Amount",IF(A1=#N/A,"The Minimum Amount")))

Where am I going wrong?
Regards,
Mick2


--
mick2
------------------------------------------------------------------------
mick2's Profile: http://www.excelforum.com/member.php...o&userid=24143
View this thread: http://www.excelforum.com/showthread...hreadid=488434

Toggle Button
 

I'm not quite sure what would make A1 equate to #NA, but try this:
=IF(A1=TRUE,"The Maximum Amount",IF(A1=FALSE,"The Median
Amount",IF(ISNA(A1),"The Minimum Amount")))

OR

=IF(A1=TRUE,"The Maximum Amount",IF(A1=FALSE,"The Median
Amount",IF(ISERROR(A1),"The Minimum Amount")))

Does that help?
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=488434

Toggle Button
 

Thanks Ron,
I tried both suggestions, but the problem is stil there.
Mick2


--
mick2
------------------------------------------------------------------------
mick2's Profile: http://www.excelforum.com/member.php...o&userid=24143
View this thread: http://www.excelforum.com/showthread...hreadid=488434

Toggle Button
 

Hi!

Do the test for #N/A first:

=IF(ISNA(A1),"The Minimum Amount",IF(A1=TRUE,"The Maximum
Amount",IF(A1=FALSE,"The Median Amount")))

Biff

"mick2" wrote in
message ...

Thanks Ron,
I tried both suggestions, but the problem is stil there.
Mick2


--
mick2
------------------------------------------------------------------------
mick2's Profile:
http://www.excelforum.com/member.php...o&userid=24143
View this thread: http://www.excelforum.com/showthread...hreadid=488434

Toggle Button
 

"Spot-On!"
It works like a charm.
Thanks, Biff.
Regards,
Mick2


--
mick2
------------------------------------------------------------------------
mick2's Profile: http://www.excelforum.com/member.php...o&userid=24143
View this thread: http://www.excelforum.com/showthread...hreadid=488434

Toggle Button
 

You're welcome.

After "looking" at this once more, the formula can be further reduced to:

=IF(ISNA(A1),"The Minimum Amount",IF(A1=TRUE,"The Maximum Amount","The
Median Amount"))

Biff

"mick2" wrote in
message ...

"Spot-On!"
It works like a charm.
Thanks, Biff.
Regards,
Mick2


--
mick2
------------------------------------------------------------------------
mick2's Profile:
http://www.excelforum.com/member.php...o&userid=24143
View this thread: http://www.excelforum.com/showthread...hreadid=488434