Triple state command button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a toggle button that is linked to a cell that I want to use in triple
state. On the 1st click the cell returns TRUE, on the 2nd click the cell
returns FALSE, but on the 3rd click the cell returns #N/A. How can I get the
cell value to show 100 on the 1st click, 200 on the 2nd click and 0 on the
3rd click.

Thanks in advance of any help.

John
 
Hi John,

Indeed the toggle button (controls toolbox) doesn't appear to trigger an
event on it's third state. However as the linked cell changes to #N/A with
the linked cell in B14 the following returns your set of values

=IF(ISERROR(B14),0,IF(B14,100,200))

Regards,
Peter T
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CheckBox / Linked Cell Problem 16
Shift Result from Start Time Formula 3
Excel message box 5
Count occurances in a range. 5
How to make tab name match cell on another sheet? 4
Arguments problem repost 3
Arguments problem 3
Compare Multiple Numeric Values 5

Back
Top