View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default precentage formula

Percentage of what?
i.e.:
Suppose your two values are in A1, and A2
A3: =ABS(A1-A2)/A2
or
A3: =ABS(A1-A2)/A1
percent difference between two of 33658.60 ~ 33.25%
percent difference between two of 44850.00 ~ 24.95%
--
John C


"Dphel" wrote:

I have 2 dollar amounts, for example $44,850.00 and $33,658.60, I need a
formula that will tell me what the precentage is for the difference between
both amounts