Thread: how to get the percentage symbol with the result?
View Single Post
  #3   Report Post  
Spencer101 Spencer101 is offline
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by sumesh56 View Post
how to get the percentage symbol with the result?
i have a farmula to calculate the percentage. i want to get the result with the percentage sign.It should be something like this.
D2=540 E2=600
F2=PERCENTAGE(D2/E2*100)%
thanks.

The formula in F2 only has to be =D2/E2 and the cell formatted as percentage.
Reply With QuoteReply With Quote