# IF Function

1. ## IF Function

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).  Register To Reply

2. ## Re: =if formula help

This has somehow ended up in the Tips and tutorials section of the forum. I'm sure a friendly mod will move it to the right forum soon.

As to your formula, you need to drop the spurious = signs

=IF(B1,E1,IF(B2,E2,IF(B3,E3,"")))

depending on the content of B1, this should work now, unless you want to specify the B1 condition a bit more ...

hth  Register To Reply

3. ## Re: =if formula help

I noticed it ended up in tips... not sure on that one.

Thanks for the help, I just figured it out as you posted.  Register To Reply