# What does this formula mean

#### bartoni

##### Active Member
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

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
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.

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.

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

Replies
6
Views
612
Replies
6
Views
207
Replies
3
Views
336
Replies
4
Views
160
Replies
18
Views
401

1,203,667
Messages
6,056,651
Members
444,880
Latest member
Kinger1968

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back