| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
I am currently using a lookup and when the number being entered a negative
amount the answer comes back as #N/A why? And what is the correct way to fix it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup
Do you have negative numbers in your table?
-- Don Guillett SalesAid Software "americasmattress8888" wrote in message ... I am currently using a lookup and when the number being entered a negative amount the answer comes back as #N/A why? And what is the correct way to fix it? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup
no, I do not the formula is
=LOOKUP(C3,{0,500,700,100,1400,1800,2000},{0.01,0. 02,0.03,0.04,0.05,0.06,0.07})*C3 "Don Guillett" wrote: Do you have negative numbers in your table? -- Don Guillett SalesAid Software "americasmattress8888" wrote in message ... I am currently using a lookup and when the number being entered a negative amount the answer comes back as #N/A why? And what is the correct way to fix it? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup
From LOOKUP help:
If lookup_value is smaller than the smallest value in lookup_vector, LOOKUP gives the #N/A error value. So a negative value is smaller than 0 hence #N/A. If value is negative, what should the LOOKUP result be? "americasmattress8888" wrote: no, I do not the formula is =LOOKUP(C3,{0,500,700,100,1400,1800,2000},{0.01,0. 02,0.03,0.04,0.05,0.06,0.07})*C3 "Don Guillett" wrote: Do you have negative numbers in your table? -- Don Guillett SalesAid Software "americasmattress8888" wrote in message ... I am currently using a lookup and when the number being entered a negative amount the answer comes back as #N/A why? And what is the correct way to fix it? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup
=IF(C3<0,"",LOOKUP(C3,{0,500,700,100,1400,1800,200 0},{0.01,0.02,0.03,0.04,0.05,0.06,0.07})*C3)
"americasmattress8888" wrote: I am currently using a lookup and when the number being entered a negative amount the answer comes back as #N/A why? And what is the correct way to fix it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
| Advanced Lookup (lookup for 2 values) | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
Hybrid Mode
