Hello Karine,

Perhaps try

=MAX(A3,F3,H3,K3,L3,M3,Z3)

"Karine" wrote:

I HAVE DATA ON MY WORKBOOK THAT LOOKS LIKE THIS
dEC 22 DEC 23 DEC 24 DEC 25 DEC 26 DEC 27
10% 35% 40% 45% 60% 70% (NOT YET INPUTED)
A3 F3 H3 K3 L3 M3 Z3
I HAVE A IF STATEMENT THAT LOOKS LIKE THIS =IF (A3<F3,F3) I NEED IT TO DO
THAT ALL THE WAY ACROSS I TRIED TO PUT A FEW IF STATMENTS IN THE IF BUT I
CAN'T FIGURE OUT THE FORMULA TO KEEP THE RECENT UPDATED DATA IN ONLY. ANY
HELP WOULD BE GREAT!

KARINE