S
Shu of AZ
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(G38>3,G38<9),((2640)-(I38*11))/(N38),IF(G38>8.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!
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(G38>3,G38<9),((2640)-(I38*11))/(N38),IF(G38>8.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!