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