Apr 23 2022 06:03 PM
Hi all,
i want to get the result, that, the order No containing A will be called "Back order", and without A, will be TIP. how do i do that using if formula?
Order No | nvoice | Status | Customer | Date | Date | Reference | Whse | Rep | Cost | Order | Shipped | GP% | Type |
2913292AA | 2591963 | T'sfer pro | ZZTOW | 23-Apr-22 | 23-Apr-22 | Stock Transfer | DGW1 | SHP | 485.67 | 559.57 | 559.57 | 13.20% | |
2913486 | 2591873 | T'sfer pro | ZZGER | 22-Apr-22 | 22-Apr-22 | CABBAGE ORDER | DGW1 | SHP | 615.1 | 0 | 0 | ******* |
Apr 23 2022 08:54 PM
@Emmanuel041 Something like this:
=IF(ISNUMBER(FIND("A",A2)),"Back order","TIP")
where A2 refers to the cell with the order no.