I am very new to excel. I am trying to add 4 columns and 3 others only if there is a maximun value in those last 3 columns. This is what I came up with but it does not work. Can anyone help?
=N2+P2+R2+T2+IF(MAX(J2:J25),+J29,+IF(MAX(K2:K25),+K29,+IF(MAX(L2:L25),+L29)))
I should have been more clear, sorry I'm new and thank you for all your responses.
The 3 columns I'm speaking of. All I want to do is look in each column, find the highest value in, let's say J2:j25 then that person associated with the high value gets another result added to his winnings. It's a golf thing. Thanks for your help sorry if this is unclear.
This message was edited by meta182 on 2002-03-27 06:34
This message was edited by meta182 on 2002-03-27 06:37
This message was edited by meta182 on 2002-03-27 10:48
=N2+P2+R2+T2+IF(MAX(J2:J25),+J29,+IF(MAX(K2:K25),+K29,+IF(MAX(L2:L25),+L29)))
I should have been more clear, sorry I'm new and thank you for all your responses.
The 3 columns I'm speaking of. All I want to do is look in each column, find the highest value in, let's say J2:j25 then that person associated with the high value gets another result added to his winnings. It's a golf thing. Thanks for your help sorry if this is unclear.
This message was edited by meta182 on 2002-03-27 06:34
This message was edited by meta182 on 2002-03-27 06:37
This message was edited by meta182 on 2002-03-27 10:48