View Single Post
  #1   Report Post  
rtillt
 
Posts: n/a
Default percent formulas

I am receiving inaccurate calculations for the following:

A B C
315 1575 500%
1 315 31500%

using formula b/a and formatiing c for %. C1 is correct, where C2 is not.
The acutal entry for A1 is 0, but get an error using 0. I also have where A
is greater than B and not receiving a negative value.

Thanks


--
Lisa