Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting to show/not show "DUE" and "RECEIVED" in cell
Hi, I am setting up a register to show when/if my drivers have handed in
their Tacho charts on time. So far I have this formula at C7 and now I'm stuck :-( =IF(A2B4+14,"DUE") A2 is =today() B4 is whatever the week commencing date may be. What I would like is for "DUE" to appear in C7 14 days after the week commencing date at B4 (so far so good!!), but when I put the number of charts received in B7 "DUE" would be changed to "RECEIVED". Hope it makes sense and you can help. Thx |
#2
|
|||
|
|||
"kevhatch" wrote: Hi, I am setting up a register to show when/if my drivers have handed in their Tacho charts on time. So far I have this formula at C7 and now I'm stuck :-( Sorry, formula should be:- =IF(A2B4+14,"DUE","") A2 is =today() B4 is whatever the week commencing date may be. What I would like is for "DUE" to appear in C7 14 days after the week commencing date at B4 (so far so good!!), but when I put the number of charts received in B7 "DUE" would be changed to "RECEIVED". Hope it makes sense and you can help. Thx |
#3
|
|||
|
|||
=IF(B7,"RECEIVED",IF(A2B4+14,"DUE"))
"kevhatch" wrote: Hi, I am setting up a register to show when/if my drivers have handed in their Tacho charts on time. So far I have this formula at C7 and now I'm stuck :-( =IF(A2B4+14,"DUE") A2 is =today() B4 is whatever the week commencing date may be. What I would like is for "DUE" to appear in C7 14 days after the week commencing date at B4 (so far so good!!), but when I put the number of charts received in B7 "DUE" would be changed to "RECEIVED". Hope it makes sense and you can help. Thx |
#4
|
|||
|
|||
What value is supposed to be in B7?
Is it an exact number (1 ... 5 ... 100), or will *any* number (0) satisfy the criteria? =IF(B7=100,"RECEIVED",IF(A2B4+14,"DUE","")) =IF(B70,"RECEIVED",IF(A2B4+14,"DUE","")) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "kevhatch" wrote in message ... Hi, I am setting up a register to show when/if my drivers have handed in their Tacho charts on time. So far I have this formula at C7 and now I'm stuck :-( =IF(A2B4+14,"DUE") A2 is =today() B4 is whatever the week commencing date may be. What I would like is for "DUE" to appear in C7 14 days after the week commencing date at B4 (so far so good!!), but when I put the number of charts received in B7 "DUE" would be changed to "RECEIVED". Hope it makes sense and you can help. Thx |
#5
|
|||
|
|||
Thx Guys, worked a treat. So easy seeing it written down.
Kev "RagDyer" wrote: What value is supposed to be in B7? Is it an exact number (1 ... 5 ... 100), or will *any* number (0) satisfy the criteria? =IF(B7=100,"RECEIVED",IF(A2B4+14,"DUE","")) =IF(B70,"RECEIVED",IF(A2B4+14,"DUE","")) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "kevhatch" wrote in message ... Hi, I am setting up a register to show when/if my drivers have handed in their Tacho charts on time. So far I have this formula at C7 and now I'm stuck :-( =IF(A2B4+14,"DUE") A2 is =today() B4 is whatever the week commencing date may be. What I would like is for "DUE" to appear in C7 14 days after the week commencing date at B4 (so far so good!!), but when I put the number of charts received in B7 "DUE" would be changed to "RECEIVED". Hope it makes sense and you can help. Thx |
#6
|
|||
|
|||
Kev,
=IF(B7<"","RECEIVED",IF(A2B4+14,"DUE","Not Yet Due")) Wasn't sure what you wanted when it wasn't either received or due. You could leave the cell blank by using =IF(B7<"","RECEIVED",IF(A2B4+14,"DUE","")) HTH, Bernie MS Excel MVP "kevhatch" wrote in message ... Hi, I am setting up a register to show when/if my drivers have handed in their Tacho charts on time. So far I have this formula at C7 and now I'm stuck :-( =IF(A2B4+14,"DUE") A2 is =today() B4 is whatever the week commencing date may be. What I would like is for "DUE" to appear in C7 14 days after the week commencing date at B4 (so far so good!!), but when I put the number of charts received in B7 "DUE" would be changed to "RECEIVED". Hope it makes sense and you can help. Thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|