PDA

View Full Version : Solved: Help with formula please



blackie42
03-02-2009, 08:40 AM
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
03-02-2009, 08:41 AM
Hi,

=MAX(A1:B1)

HTH

blackie42
03-02-2009, 08:58 AM
Hi - new it was simple but wouldn't come to me

thanks again

Jon