| 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 |
| 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 | |||
Threaded Mode
