| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a maximum number of constraints...
....that I can put in an IF formula?
I have a chart with age bands (i.e 20-24, 25-29, 30-35, etc. and corresponding amounts for those age bands (247.84, 256.69, 274.39, respectively). My current formula reads: =IF(I116<25,247.84,IF(I116<30,256.69,IF(I116<35,27 4.39,IF(I116<40,295.63,IF(I116<45,322.21,IF(I116<5 0,354.08,IF(I116<55,404.51,IF(I116<60,490.7,IF(I11 6<65,652.03,IF(I116=65,884.34,N/A)))))))) Excel is giving me an error message at the IF where IF(I116<65,652.03.... I've double checked to make sure there are no spaces, and when I remove that constraint and the ones that follow, the formula works. Help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| What is the maximum allowed number of data elements in a data array? | Excel Discussion (Misc queries) | |||
| getting the number of the row with the maximum value | Excel Discussion (Misc queries) | |||
| maximum number of spreadsheets in one workbook | Excel Discussion (Misc queries) | |||
| what is maximum number of colums in worksheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
