Explain these please
 

Hello you techies out there. I have been asked to explain the following -
can anybody make clear to me so I acn in turn explain to others. Thank you.
=IF('TL Table'!A6="","",IF('TL Table'!A6="(blank)","",'TL Table'!A6))

=IF(B3="",IF(D3="","",J2),RIGHT(B3,10))

=IF(A4="","Z",VLOOKUP(LEFT(A4,4),TEAMS!A:D,3,FALSE ))

=COUNTIF(P$4:P$19,$A24)

=ROUND(L20*$C20*7*(1-$C$27),0)

ROUND(H45*$C45*7*(1-($C68+$C69)),0)+(H54*$C54*7*(1-$C69))

I would be grateful for any help.

Kind regards.
Sal

Get into Excel
Press F1
Type...
IF worksheet function then
select Search
Read the answer
Do the same thing for vLookup, Right, CountIf and Round.

the 'TL Table'!A6 syntax means, in cell A6 of the worksheet called TL Table.
HTH,
Techie


"Sal" wrote:

Hello you techies out there. I have been asked to explain the following -
can anybody make clear to me so I acn in turn explain to others. Thank you.
=IF('TL Table'!A6="","",IF('TL Table'!A6="(blank)","",'TL Table'!A6))

=IF(B3="",IF(D3="","",J2),RIGHT(B3,10))

=IF(A4="","Z",VLOOKUP(LEFT(A4,4),TEAMS!A:D,3,FALSE ))

=COUNTIF(P$4:P$19,$A24)

=ROUND(L20*$C20*7*(1-$C$27),0)

ROUND(H45*$C45*7*(1-($C68+$C69)),0)+(H54*$C54*7*(1-$C69))

I would be grateful for any help.

Kind regards.
Sal