Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trouble with my formula
=PRODUCT(I478,VLOOKUP(G478,$AV$365:$AW$389,2))This formula is correct the
data it reads from is correct and yet there are 5 or 6 error inputs. This is what happens when I input numbers 8x6 167 8x8 167 10x6 22.50 10x10 N/A 12x6 29 Etc... I have a list of 22 sizes in column AV and their prices in column AW Most of them work and fine but the first two read the prices of the last one. And some of the earlier ones read n/a. But then it smooths and works for the remaining ones and I can't figure out why. The multiple that it is being multiplied by is an if formula =IF(N478="Aluminum",1,IF(N478="Steel",0.9)) Now I have used this formula multiple times in the worksheet and have used the mutiple in those formulas as well some of them using upwards of 40 variables. What would be causing this and why? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trouble with my formula
Try it like this:
I478*VLOOKUP(G478,$AV$365:$AW$389,2,0) -- Biff Microsoft Excel MVP "Excluxe" wrote in message ... =PRODUCT(I478,VLOOKUP(G478,$AV$365:$AW$389,2))This formula is correct the data it reads from is correct and yet there are 5 or 6 error inputs. This is what happens when I input numbers 8x6 167 8x8 167 10x6 22.50 10x10 N/A 12x6 29 Etc... I have a list of 22 sizes in column AV and their prices in column AW Most of them work and fine but the first two read the prices of the last one. And some of the earlier ones read n/a. But then it smooths and works for the remaining ones and I can't figure out why. The multiple that it is being multiplied by is an if formula =IF(N478="Aluminum",1,IF(N478="Steel",0.9)) Now I have used this formula multiple times in the worksheet and have used the mutiple in those formulas as well some of them using upwards of 40 variables. What would be causing this and why? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trouble with my formula
Thanks for the advice it worked
"T. Valko" wrote: Try it like this: I478*VLOOKUP(G478,$AV$365:$AW$389,2,0) -- Biff Microsoft Excel MVP "Excluxe" wrote in message ... =PRODUCT(I478,VLOOKUP(G478,$AV$365:$AW$389,2))This formula is correct the data it reads from is correct and yet there are 5 or 6 error inputs. This is what happens when I input numbers 8x6 167 8x8 167 10x6 22.50 10x10 N/A 12x6 29 Etc... I have a list of 22 sizes in column AV and their prices in column AW Most of them work and fine but the first two read the prices of the last one. And some of the earlier ones read n/a. But then it smooths and works for the remaining ones and I can't figure out why. The multiple that it is being multiplied by is an if formula =IF(N478="Aluminum",1,IF(N478="Steel",0.9)) Now I have used this formula multiple times in the worksheet and have used the mutiple in those formulas as well some of them using upwards of 40 variables. What would be causing this and why? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trouble with my formula
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Excluxe" wrote in message ... Thanks for the advice it worked "T. Valko" wrote: Try it like this: I478*VLOOKUP(G478,$AV$365:$AW$389,2,0) -- Biff Microsoft Excel MVP "Excluxe" wrote in message ... =PRODUCT(I478,VLOOKUP(G478,$AV$365:$AW$389,2))This formula is correct the data it reads from is correct and yet there are 5 or 6 error inputs. This is what happens when I input numbers 8x6 167 8x8 167 10x6 22.50 10x10 N/A 12x6 29 Etc... I have a list of 22 sizes in column AV and their prices in column AW Most of them work and fine but the first two read the prices of the last one. And some of the earlier ones read n/a. But then it smooths and works for the remaining ones and I can't figure out why. The multiple that it is being multiplied by is an if formula =IF(N478="Aluminum",1,IF(N478="Steel",0.9)) Now I have used this formula multiple times in the worksheet and have used the mutiple in those formulas as well some of them using upwards of 40 variables. What would be causing this and why? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'IF' formula trouble | Excel Discussion (Misc queries) | |||
Trouble with an IF formula | Excel Worksheet Functions | |||
Trouble with formula | Excel Discussion (Misc queries) | |||
Trouble with formula | Excel Worksheet Functions | |||
Formula Trouble | Excel Worksheet Functions |