Excel Round
 

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.

Excel Round
 

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.

Excel Round
 

On Sep 1, 2:48 pm, Max wrote:
Replace this term: VLOOKUP(D10,Customers,9)
with this: TEXT(ROUND(VLOOKUP(D10,Customers,9),2),"0%")
--


I think you mean:
TEXT(ROUND(VLOOKUP(D10,Customers,9),2),"0.00%")

Excel Round
 

On Sep 1, 2:48 pm, Max wrote:
Replace this term: VLOOKUP(D10,Customers,9)
with this: TEXT(ROUND(VLOOKUP(D10,Customers,9),2),"0%")
--

Shoot! Didn't finish that off properly. Ignore my first post.

2nd try, if the OP wants a percent with 2 decimal places:
TEXT(ROUND(VLOOKUP(D10,Customers,9),4),"0.00%")