Choose function gives different results from different cells?????
 

I have a formula that contains a choose function with absolute cell
references. When I copy and paste this formula to other cells some result in
true, some in false and some in a Value error. The one place I really need
it to work it always resolves to a value error. What is causing this?

Choose function gives different results from different cells?????
 

Your problem is intriguing, but without your formula it'll be difficult to
give you meaningful help.


***********
Regards,
Ron

XL2002, WinXP-Pro


"Dan @united_brokers" wrote:

I have a formula that contains a choose function with absolute cell
references. When I copy and paste this formula to other cells some result in
true, some in false and some in a Value error. The one place I really need
it to work it always resolves to a value error. What is causing this?

Choose function gives different results from different cells??
 

=IF(CHOOSE(VALUE(LEFT($I$1,1)),$AA$80:$AA$128,$AB$ 80:$AB$128,$AC$80:$AC$128,$AD$80:$AD$128)="YES","S urplus Lines Tax","")

from some cells (below the print area) it evaluates to true, from others to
false. Within the print area it gives a Value error.



"Ron Coderre" wrote:

Your problem is intriguing, but without your formula it'll be difficult to
give you meaningful help.


***********
Regards,
Ron

XL2002, WinXP-Pro


"Dan @united_brokers" wrote:

I have a formula that contains a choose function with absolute cell
references. When I copy and paste this formula to other cells some result in
true, some in false and some in a Value error. The one place I really need
it to work it always resolves to a value error. What is causing this?

Choose function gives different results from different cells??
 

Posting your formula helps.
=IF(CHOOSE(VALUE(LEFT($I$1,1)),$AA$80:$AA$128,$AB$ 80:$AB$128,$AC$80:$AC$128,$AD$80:$AD$128)="YES","S urplus Lines Tax","")

One more piece is missing:
What cell(s) hold that formula?

As it stands, that formula will return "Surplus Lines Tax" or "" only if the
formula is located in a cell in rows 80 through 128. Otherwise, it returns
#VALUE! because all other rows do not intersect with any of the referenced
ranges. Is that what you intended?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Dan @united_brokers" wrote:

=IF(CHOOSE(VALUE(LEFT($I$1,1)),$AA$80:$AA$128,$AB$ 80:$AB$128,$AC$80:$AC$128,$AD$80:$AD$128)="YES","S urplus Lines Tax","")

from some cells (below the print area) it evaluates to true, from others to
false. Within the print area it gives a Value error.



"Ron Coderre" wrote:

Your problem is intriguing, but without your formula it'll be difficult to
give you meaningful help.


***********
Regards,
Ron

XL2002, WinXP-Pro


"Dan @united_brokers" wrote:

I have a formula that contains a choose function with absolute cell
references. When I copy and paste this formula to other cells some result in
true, some in false and some in a Value error. The one place I really need
it to work it always resolves to a value error. What is causing this?