Thread: Excel Round
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
  
Posts: 622
Default 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%")
Reply With QuoteReply With Quote