ExcelBanter - Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formulas (https://www.excelbanter.com/excel-worksheet-functions/7749-formulas.html)

GBH99

Formulas

How can I programme excel so that if Column A is filled in for a value then
it will ignore any values in Column B?

Frank Kabel

Hi
and what do you want to do with this information afterwards?

--
Regards
Frank Kabel
Frankfurt, Germany

GBH99 wrote:
How can I programme excel so that if Column A is filled in for a
value then it will ignore any values in Column B?

K.S.Warrier

Hi,
In C1,put
=if(A10,A1,B1)
and copy this down in column C.
Thank you,
K.S.Warrier

"Frank Kabel" wrote:

Hi
and what do you want to do with this information afterwards?

--
Regards
Frank Kabel
Frankfurt, Germany

GBH99 wrote:
How can I programme excel so that if Column A is filled in for a
value then it will ignore any values in Column B?

All times are GMT +1. The time now is 03:41 PM.