| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I nest Max in HLOOKUP? | Excel Worksheet Functions | |||
| how do I nest 3 items? | Excel Worksheet Functions | |||
| how do I nest functions | Excel Worksheet Functions | |||
| How do I nest these 3 IF functions? | Excel Worksheet Functions | |||
| HOW DO I NEST MORE THAN 1 IF FUNCTION? | Excel Worksheet Functions | |||
Linear Mode
