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

  • Thread starter Dan @united_brokers
  • Start date
D

Dan @united_brokers

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?
 
R

Ron Coderre

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


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

XL2002, WinXP-Pro
 
D

Dan @united_brokers

=IF(CHOOSE(VALUE(LEFT($I$1,1)),$AA$80:$AA$128,$AB$80:$AB$128,$AC$80:$AC$128,$AD$80:$AD$128)="YES","Surplus 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.
 
R

Ron Coderre

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","Surplus 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
 
Top