NEST A IF WITHIN A IF

[Karine]

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

 

[Pete_UK]

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

 

[daddylonglegs]

Hello Karine,

Perhaps try

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

 

[Karine]

Sorry for the caps my intent wasnt to be rude. Thanks for the help.

Karine

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Sorry for the caps my intent wasnt to be rude. Thanks for the help.

Karine







- Show quoted text -