Can someone help me to understand how this formula works? =IF(E3.

G

Guest

it says...
if the value in cell E3=0, display a value of 1 in the
cell with the IF formula in it.
if the value in cell E3 is NOT =0, calculate the sum of
the values in cells I3 and J3, divide that sum by the sum
of the values in cells G3 through J3, subtract that
division result from 1, and display that subtraction
result in the cell with the IF formula in it.

If you need more explanation, post back.
 
L

LynnF

Thank you!!

[email protected] said:
it says...
if the value in cell E3=0, display a value of 1 in the
cell with the IF formula in it.
if the value in cell E3 is NOT =0, calculate the sum of
the values in cells I3 and J3, divide that sum by the sum
of the values in cells G3 through J3, subtract that
division result from 1, and display that subtraction
result in the cell with the IF formula in it.

If you need more explanation, post back.
Click to expand...
 
Top