IF formular with statement "end with"

[Emmanuel041]

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

*******

[#2]

@Emmanuel041 Something like this:

=IF(ISNUMBER(FIND("A",A2)),"Back order","TIP")

where A2 refers to the cell with the order no.