Toggle Button

[mick2]

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

[Ron Coderre]

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

[mick2]

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

[Biff]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[mick2]

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

[Biff]

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" <[email protected]> wrote in
message news:[email protected]...
>
> "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
>