IF Functions

[Roachy]

Probabally a really simple question but Im looking to do my IF function in a
couple of stages firstly to check cell L72 and check if the value is greater
than 1 bringing back the value in F72 if true.

Then moves onto L71 and adds the value of F71 to the origional numbers above
(if the value of L71 doesnt = 0) and so on and so on....

=IF(L72>1,(F72+IF(L71=0,F71)+IF(L70=0,F70)))

Hope this makes sence

Please help

 

[Bob Phillips]

=IF(L72>1,F72,0)+SUMIF(L70:L71,"<>0",F70:F71)

Just change the L71 and F71 to your final row.

 

[Roger Govier]

Hi

I'm not really understanding your problem.
Your statement says if L71=0, add F71, but your text says

(if the value of L71 doesn't = 0)

Instead of Multiple If's you could use
=IF(L72>1,F72+F71*(L71<>0)+F70*(L70<>0) ....... ,"")

the sting of dots ... is for you to add as many other expressions of the
type shown,
with the final ,"" representing what you want to happen if L72 is not >1.

Each Expression
F71*(L71<>0)
will evaluate to either the value in F71 if L71<>0 or 0 if it is not.

 

[Roachy]

Cheers Bob worked a treat

=IF(L72>1,F72,0)+SUMIF(L70:L71,"<>0",F70:F71)

Just change the L71 and F71 to your final row.

--
__________________________________
HTH

Bob