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