Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Explain Pivot tables & charts | Charts and Charting in Excel | |||
Chat Room | New Users to Excel | |||
Sorry, this is a repost, cuz i didn't explain myself right | Excel Discussion (Misc queries) | |||
Excel help should explain how to change r1c1 to a1 | Excel Discussion (Misc queries) | |||
Problems with hyperlinks | Excel Discussion (Misc queries) |