Data Validation to Change Adjacent Formula

[McGu]

Hey guys and gals,

I'm sure that it is on here somewhere, but I am all out of search terms regarding changing an adjacent cells' forumla based on the selection from a data validation drop down list. I'm sure that it has to do something with IF, but if there is better way, please point me in the right direction.

So the problem goes like this:

In cell A1 a data validation list offers the possible selections (Yes, No)
Cell B2 then changes its forumla based on the selection of cell A1. Cell B2 has formula =C3/D4 if A1="Yes" if cell A1="No" then C3 + D4.

Many thanks.

 

[Von Pookie]

How about:

=IF(A1="Yes",C3/D4,C3+D4)

 

[McGu]

Yeah, thanks. I figured that's what it would be. I was jsut wondering if there was something else that I should be looking at. I guess the old adage of KISS (keep it simple stupid) applies here. Thanks.