Here is what I think it should look like
=IF(B1,E1,=IF(B2,E2,=IF(B3,E3,"")))
This formula is in cell A
What I am trying to say is that if B1 is true use E1 but if it's false check to see if b2 is true and if it is use e2, if it is false check to see if b3 is true and if it is use e3 if it's false leave the cell blank
B1, 2 and 3 are tied to option buttons. The user can select only one option button. Depending on what button he selects I want one of three values (E1, 2 or 3) returned to this one cell (A1).
Bookmarks