new cell value based on value in another column same row

river

New Member
Joined
Jun 9, 2011
Messages
25
I hope this can be done with a simple conditional statement:
I have columns A B C of data.
If the value of column B is False I would like column C to be populated with the corresponding values in column A.

A B C
123 True (blank)
456 False 456
789 True (blank)
abc False abc

If I can't use a formula I could create a macro. The dataset is small but I'll be using the formula as I create new worksheets.
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.

river

New Member
Joined
Jun 9, 2011
Messages
25
Thanks so much. I was close but being too literal using "FALSE" with quotes. Very simple.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,471
Messages
5,596,345
Members
414,060
Latest member
hermanseck

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