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.
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

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.
 

Forum statistics

Threads
1,141,155
Messages
5,704,618
Members
421,360
Latest member
Rhodia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top