Replace this term: VLOOKUP(D10,Customers,9)
with this: TEXT(ROUND(VLOOKUP(D10,Customers,9),2),"0%")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---
"Terri" wrote:
Hi: I need to round a formula from a decimal to a percent here is the
foemula,=VLOOKUP(D10,Customers,9)&"/"&VLOOKUP(D10,Customers,10,FALSE)&"
"&VLOOKUP(D10,Customers,11,FALSE)&" "&VLOOKUP(D10,Customers,12,FALSE) I need
to put the percent in the first vlookup it is now showing as a decimal but I
want to round it to 2 decimal places and have a percent sign. any help would
be greatly appriciated.