comparing values

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Is there an easy way to compare the numeric value of 2
fields and return a percentage of variance? Sometimes
column A might be greater than B and sometimes B is
greater than A. I don't want a negative value just the
variance.
Thanks in advance for any help!
 
Hi Kevin
if A1 is the base value and A2 the value to be compared try
=(ABS(A2-A1))/A1
format as percentage
Frank
 
Back
Top