What does this formula mean

[bartoni]

Hi,

What do these formulas mean?

i under stand if N117 is 0 then average (Q62:67), what does the middle zero mean though?

=IF($N$117=0,0,AVERAGE(Q62:Q67))

i take it this is If K111 is Ture then put a blank in L124?

=IF($K$111=TRUE,L124,"")

Many Thanks

 

[S.H.A.D.O.]

Hi bartoni,

The First Formula ...
=IF($N$117=0, 0 ,AVERAGE(Q62:Q67))
... Means that if $N$117=0 then Put a 0, Otherwise AVERAGE(Q62:Q67))

The Second Formula ...
=IF($K$111=TRUE,L124,"")
... Means that if $K$111=TRUE then Put the Value that is in Cell L124, Otherwise Put a Blank ( "" ).

Hope this Helps.
All the Best.
SHADO

 

[Andrew Poulsom]

It's If ... Then ... Else.

So the first formula means return zero if N117 is zero, else return the average of Q62:Q67.. The second means return what's in L124 if K111 is TRUE, else return "".

In both cases it's the cell containing the formula that will show the returned result.

 

[bartoni]

Thanks,

Does anyone know where i can find a list of good examples using the

IF function on the net both advanced and basic?

Many Thanks