Thread: percentage
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
formula101 formula101 is offline
external usenet poster
 
Posts: 2
Default percentage

I am trying to get the correct amount by using the following formula:

=c3/d3 to get percentage amount
c3 is 12.74
d3 is 19.81

my percentage in e3 equals 64% with no decimals

I then take:
e3*f3 to equal G3

e3 is 64%
f3 is $21.39

G3 calculate is $13.76
It should be $13.69

I do not know what I am doing incorrectly.

Thank you,