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!!

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top