Solved: Help with formula please

[blackie42]

Hi

Have a situation where I need to identify which number is the higher of 2 columns and then display the number in the adjacent column,

E.g. A1 = £5000 B1 = £6000 C1(formula) therefore = £6000

Any help appreciated

thanks
Jon

[Krishna Kumar]

Hi,

=MAX(A1:B1)

HTH

[blackie42]

Hi - new it was simple but wouldn't come to me

thanks again

Jon