Formulas

GBH99 · Dec 10, 2004

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 · Dec 10, 2004

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

K.S.Warrier · Dec 10, 2004

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