R
Realitygdk
The formula is supposed to be saying multiply Column (G), which in
this case has a 1/16 in it, and multiply number by Column C which has
a 2 in it, and then place that number in Column (I). The Column (J)
is to Look into the named range Fraction and enter the corresponding
weight label "ounce" or "pounds", but since I cannot make the Look Up
work I have enter the is greater or not greater to hopefully arrive at
the same correct label..
VLOOKUP Table Fraction
VLOOKUP Table Decimal
VLOOKUP Table D2ecimal
A B C D E F G H I J
Name Number At Fraction Fraction Total Total
Of Of Postage Dollars Weight Weight Weight Weight
Department Pieces Rate Of Amount Foz_Fib Ftype Foz_Fib Ftype
Date Dept Pieces Rate Amt Fozib Flabel Fozib Flabel
January 1, 2008 Administration 2 $0.41 $0.82 1/16 0 #VALUE!
#VALUE!
The following formula is in Column (I):
=IF(ISERROR(VLOOKUP(D14,FRate,2,FALSE)),0,(VLOOKUP(D14,FRate,2)))
and this formula listed below is in Column (J)
=IF(I8<=0.8125,"ounce","pounds")
My problems are as follows:
1/16 equals .41 in the Named Range called Fraction and here it should
be multiply by the 2 from the (J) Column and then that value is to be
looked up in the named ranged called Fraction
The second formula is then to Look Up the value in the (J) Column and
then assign an ounce or pound depending of if the weight is under 16
ounces or over.
Any help or suggestion is mot appreciated, as I have been at this for
awhile and the formula seemed to be stating what I had just made
referenced to but the results are not what I am expecting.
this case has a 1/16 in it, and multiply number by Column C which has
a 2 in it, and then place that number in Column (I). The Column (J)
is to Look into the named range Fraction and enter the corresponding
weight label "ounce" or "pounds", but since I cannot make the Look Up
work I have enter the is greater or not greater to hopefully arrive at
the same correct label..
VLOOKUP Table Fraction
VLOOKUP Table Decimal
VLOOKUP Table D2ecimal
A B C D E F G H I J
Name Number At Fraction Fraction Total Total
Of Of Postage Dollars Weight Weight Weight Weight
Department Pieces Rate Of Amount Foz_Fib Ftype Foz_Fib Ftype
Date Dept Pieces Rate Amt Fozib Flabel Fozib Flabel
January 1, 2008 Administration 2 $0.41 $0.82 1/16 0 #VALUE!
#VALUE!
The following formula is in Column (I):
=IF(ISERROR(VLOOKUP(D14,FRate,2,FALSE)),0,(VLOOKUP(D14,FRate,2)))
and this formula listed below is in Column (J)
=IF(I8<=0.8125,"ounce","pounds")
My problems are as follows:
1/16 equals .41 in the Named Range called Fraction and here it should
be multiply by the 2 from the (J) Column and then that value is to be
looked up in the named ranged called Fraction
The second formula is then to Look Up the value in the (J) Column and
then assign an ounce or pound depending of if the weight is under 16
ounces or over.
Any help or suggestion is mot appreciated, as I have been at this for
awhile and the formula seemed to be stating what I had just made
referenced to but the results are not what I am expecting.