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