Data Validation to Change Adjacent Formula

McGu

Board Regular
Joined
Oct 10, 2006
Messages
135
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.
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

McGu

Board Regular
Joined
Oct 10, 2006
Messages
135
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,111,596
Messages
5,541,150
Members
410,543
Latest member
ExcelGlenn
Top