Danskylansky
New Member
- Joined
- Mar 10, 2016
- Messages
- 2
Hi All
I am trying to use an If statement to return a particular amount if a corresponding cell, on another table has a date (only - if it contains anything else i need it to be blank. Here are the tables:
Table 1:
<tbody>
</tbody>Table 2:
<tbody>
</tbody>
I need the correct IF Statement to be applied on the first table: =if('table2'B2=date,'table1'B2,""). I realise that just using =date is not correct, but can't workout the correct function name to use
My problem is getting the if statement to only recognise if a date has been used in the corresponding cell.
Any help would be appreciated
Thanks
I am trying to use an If statement to return a particular amount if a corresponding cell, on another table has a date (only - if it contains anything else i need it to be blank. Here are the tables:
Table 1:
Initials | Day 0 | Day 7 | Day 14 | Delivery |
$500 | $300 | $800 | $1500 | |
M001 | $500 | $300 | ||
M002 | $500 | $1500 |
<tbody>
</tbody>
Initials | Day 0 | Day 7 | Day 14 | Delivery |
M001 | 01/01/2016 | 05/02/2016 | 08/03/2016 | |
M002 | 03/01/2016 | NA | NA | 12/03/2016 |
<tbody>
</tbody>
I need the correct IF Statement to be applied on the first table: =if('table2'B2=date,'table1'B2,""). I realise that just using =date is not correct, but can't workout the correct function name to use
My problem is getting the if statement to only recognise if a date has been used in the corresponding cell.
Any help would be appreciated
Thanks