| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
| what function can i use to tell me if 2 text cells are the same? | Excel Worksheet Functions | |||
| How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
| Using function results as parameters in another function | Excel Worksheet Functions | |||
| Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions | |||
Linear Mode
