if function

  • Thread starter Thread starter sd
  • Start date Start date
S

sd

i have text in cell a5 Ash Private Limited what i want is
in cell b5 that if cell a5 have text "Private Limited"
than it should that wright 13 in b5 other wise it should
wright 12 in b5.

how can i use if function here?

any help.

Sd
 
sd said:
i have text in cell a5 Ash Private Limited what i want is
in cell b5 that if cell a5 have text "Private Limited"
than it should that wright 13 in b5 other wise it should
wright 12 in b5.

how can i use if function here?
Click to expand...

If you mean the condition is for A5 to equal just "Private Limited", use
=IF(A5="Private Limited",13,12)

If you mean the condition is for the text in A5 to end with "Private
Limited", use
=IF(RIGHT(A5,15)="Private Limited",13,12)

If you mean the condition is for the text "Private Limited" to be anywhere
in A5, use
=IF(ISNUMBER(FIND("Private Limited",A5)),13,12)
 
Back
Top