Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Lisa,
31500% is correct for C2. If you want to show a -0- if the denominator is -0-, put this formula in C1... =if(A1=0,0,b1/a1) <<I also have where A is greater than B and not receiving a negative value. I -THINK- what you want is a formula such as... =IF(A1=0,0,IF(B1=A1,B1/A1,IF(B1=0,0,-A1/B1))) HTH, -- Gary Brown Please rate this posting if it is helpful to you. "rtillt" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
percent formulas | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |