| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NUM Error
Below is a set of cells where the EP is a number derived from other cell's
contents. The # field is a static set of numbers. The LargeEP only sorts the EP in sets of three and then the Lookup displays which # attributes to the highest number in each set. Other cells which use the large or the lookup will not work as long as the Num error exists. I tried to make the EP formula display a zero if it was false but it continues to say FALSE or it errors with 'Too many arguemnts". Here is the EP formula, any help would be greatly appreciated. =IF(AND(G383,G38<9),((2640)-(I38*11))/(N38),IF(G388.9,((3960)-(I38*11))/((N38-100+60)))) EP # LargeEP VLookupEP 57.140 1 58.094 2 58.094 2 57.948 3 57.948 3 57.140 1 59.339 1 59.339 1 FALSE 2 #NUM! #NUM! FALSE 3 #NUM! #NUM! 56.366 1 56.366 1 FALSE 2 #NUM! #NUM! FALSE 3 #NUM! #NUM! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NUM Error
This is a condensed view
EarlyPace LargeEP VLookupEP 59.339 1 59.339 1 FALSE 2 #NUM! #NUM! FALSE 3 #NUM! #NUM! "Shu of AZ" wrote: Below is a set of cells where the EP is a number derived from other cell's contents. The # field is a static set of numbers. The LargeEP only sorts the EP in sets of three and then the Lookup displays which # attributes to the highest number in each set. Other cells which use the large or the lookup will not work as long as the Num error exists. I tried to make the EP formula display a zero if it was false but it continues to say FALSE or it errors with 'Too many arguemnts". Here is the EP formula, any help would be greatly appreciated. =IF(AND(G383,G38<9),((2640)-(I38*11))/(N38),IF(G388.9,((3960)-(I38*11))/((N38-100+60)))) EP # LargeEP VLookupEP 57.140 1 58.094 2 58.094 2 57.948 3 57.948 3 57.140 1 59.339 1 59.339 1 FALSE 2 #NUM! #NUM! FALSE 3 #NUM! #NUM! 56.366 1 56.366 1 FALSE 2 #NUM! #NUM! FALSE 3 #NUM! #NUM! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NUM Error
Hi
Try: =IF(AND(G33,G3<9),((2640)-(I38*11))/(N38),IF(G38.9,((3960)-(I38*11))/((N38-100+60)),0)) HTH Jean-Guy "Shu of AZ" wrote: This is a condensed view EarlyPace LargeEP VLookupEP 59.339 1 59.339 1 FALSE 2 #NUM! #NUM! FALSE 3 #NUM! #NUM! "Shu of AZ" wrote: Below is a set of cells where the EP is a number derived from other cell's contents. The # field is a static set of numbers. The LargeEP only sorts the EP in sets of three and then the Lookup displays which # attributes to the highest number in each set. Other cells which use the large or the lookup will not work as long as the Num error exists. I tried to make the EP formula display a zero if it was false but it continues to say FALSE or it errors with 'Too many arguemnts". Here is the EP formula, any help would be greatly appreciated. =IF(AND(G383,G38<9),((2640)-(I38*11))/(N38),IF(G388.9,((3960)-(I38*11))/((N38-100+60)))) EP # LargeEP VLookupEP 57.140 1 58.094 2 58.094 2 57.948 3 57.948 3 57.140 1 59.339 1 59.339 1 FALSE 2 #NUM! #NUM! FALSE 3 #NUM! #NUM! 56.366 1 56.366 1 FALSE 2 #NUM! #NUM! FALSE 3 #NUM! #NUM! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom error bars not working | Charts and Charting in Excel | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Problem Opening an Excel File MSO9.DLL Error | Links and Linking in Excel | |||
| error "module not found" | Excel Discussion (Misc queries) | |||
| #REF error | Excel Worksheet Functions | |||
Linear Mode
