i'm currently designing an invoice for a local company. I have arranged stock codes and item names by way of look up. How ever if the "stock code" and "item" column are blank, N/A appears within the "item". How can i use IF staements to get around this?, i.e IF the stock code is blank nothing appears in the "item" column.
Any help is appreciated.
Chogger.
Any help is appreciated.
Chogger.