adding a round function to an existing formula
 

The value in some of the fields to look up are decimals.
EX: The result in the field is 5.6. The lookup is seeing this as 5 instead
of 6. My formula is below. I am somewhat new to


=IF(ISERROR(VLOOKUP(D5,'LOOKUP
TABLES'!$A$3:$D$13,2))=TRUE,"",(VLOOKUP(D5,'LOOKUP
TABLES'!$A$3:$D$13,2))*0.25)

adding a round function to an existing formula
 

Vlookup will take results of calculations as easily as a cell address. Use:

=IF(ISERROR(VLOOKUP(round(D5,0),'LOOKUP
TABLES'!$A$3:$D$13,2)),"",VLOOKUP(round(D5,0),'LOO KUP
TABLES'!$A$3:$D$13,2)*0.25)

Regards,
Fred

"Deb Paiement" <Deb wrote in message
...
The value in some of the fields to look up are decimals.
EX: The result in the field is 5.6. The lookup is seeing this as 5 instead
of 6. My formula is below. I am somewhat new to


=IF(ISERROR(VLOOKUP(D5,'LOOKUP
TABLES'!$A$3:$D$13,2))=TRUE,"",(VLOOKUP(D5,'LOOKUP
TABLES'!$A$3:$D$13,2))*0.25)

adding a round function to an existing formula
 

Worked great! Thank you!

"Fred Smith" wrote:

Vlookup will take results of calculations as easily as a cell address. Use:

=IF(ISERROR(VLOOKUP(round(D5,0),'LOOKUP
TABLES'!$A$3:$D$13,2)),"",VLOOKUP(round(D5,0),'LOO KUP
TABLES'!$A$3:$D$13,2)*0.25)

Regards,
Fred

"Deb Paiement" <Deb wrote in message
...
The value in some of the fields to look up are decimals.
EX: The result in the field is 5.6. The lookup is seeing this as 5 instead
of 6. My formula is below. I am somewhat new to


=IF(ISERROR(VLOOKUP(D5,'LOOKUP
TABLES'!$A$3:$D$13,2))=TRUE,"",(VLOOKUP(D5,'LOOKUP
TABLES'!$A$3:$D$13,2))*0.25)