PLEASE do not SHOUT, or type in UPPER CASE throughout - it is
difficult to read, and considered rude.

I think this might do what you want:

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

It will pick the largest value from the seven.

Hope this helps.

Pete

On Nov 27, 7:28 pm, 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