Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there any way to round to the nearest 1/8, 1/4, etc in Excel. | Excel Worksheet Functions | |||
How can I round to a 0 or 0.5 in Excel? | Excel Worksheet Functions | |||
How do I round down to nearest .05% in Excel? | Excel Discussion (Misc queries) | |||
IN EXCEL, ROUND 10.45 T0 10.5 OR 10.27 TO 10.25 | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |