Hey Everyone
I am trying to get a report for work, and I have a specific idea of what I need to do.
<tbody>
</tbody>
Does anyone know how to make this work for me??
I am trying to get a report for work, and I have a specific idea of what I need to do.
A | B | C | D | E | F | |
1 | SKU | Description | O/H | O/O | Price | Clearance |
2 | 123456 | Candy | 10 | 5 | 19.94 | If E2 Ends in a 4, F2=Y. If E2 Ends in anything else except for 4, then F2=N. In this case F2=N |
3 | 987654 | Pop | 5 | 9 | 9.94 | If E3 Price ends in a 4, F3=Y. If E3 ends in anything else except for 4, then F3=NIn this case, F3=Y |
<tbody>
</tbody>
Does anyone know how to make this work for me??