Thread: adding a round function to an existing formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deb Paiement Deb Paiement is offline
external usenet poster
  
Posts: 1
Default 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)
Reply With QuoteReply With Quote