NEST A IF WITHIN A IF
 

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

NEST A IF WITHIN A IF
 

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

NEST A IF WITHIN A IF
 

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

NEST A IF WITHIN A IF
 

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

Karine

"Pete_UK" wrote:

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

NEST A IF WITHIN A IF
 

You're welcome - thanks for feeding back.

Pete

On Nov 27, 7:51 pm, Karine wrote:
Sorry for the caps my intent wasnt to be rude. Thanks for the help.

Karine



"Pete_UK" wrote:
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 - Hide quoted text -

- Show quoted text -