Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
toggle button text color | Excel Discussion (Misc queries) | |||
Toggle button | Excel Discussion (Misc queries) | |||
Toggle Button | Excel Discussion (Misc queries) | |||
Place the caption of a toggle button into a cell | Excel Worksheet Functions | |||
Toggle betwen "editing" and "pushing" a button in excel | Excel Discussion (Misc queries) |