| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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%") |
| 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 | |||
Threaded Mode
