IF Functions
 

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(L721,(F72+IF(L71=0,F71)+IF(L70=0,F70)))

Hope this makes sence

Please help

IF Functions
 

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

Just change the L71 and F71 to your final row.

--
__________________________________
HTH

Bob

"Roachy" wrote in message
...
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(L721,(F72+IF(L71=0,F71)+IF(L70=0,F70)))

Hope this makes sence

Please help

IF Functions
 

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(L721,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.

--
Regards
Roger Govier

"Roachy" wrote in message
...
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(L721,(F72+IF(L71=0,F71)+IF(L70=0,F70)))

Hope this makes sence

Please help

IF Functions
 

Cheers Bob worked a treat

"Bob Phillips" wrote:

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

Just change the L71 and F71 to your final row.

--
__________________________________
HTH

Bob

"Roachy" wrote in message
...
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(L721,(F72+IF(L71=0,F71)+IF(L70=0,F70)))

Hope this makes sence

Please help