W.E.B

asked on

# Excel formula if

Hello,

can you please help,

I'm trying to say, if left of cell like then

=IF(LEFT(AK2,10)="RESIDENCE",AM2+3,IF(LEFT(AK2,11)="RESIDENTIAL",AM2+3,IF(LEFT(AK2,9)="RESIDENT",AM2+3,AM2)))

it seems to work only on exact words.

Example

if the cells was

RESIDENCE_____

RESIDENTIAL ---

RESIDENT yes

formula doesn't work.

thanks

can you please help,

I'm trying to say, if left of cell like then

=IF(LEFT(AK2,10)="RESIDENC

it seems to work only on exact words.

Example

if the cells was

RESIDENCE_____

RESIDENTIAL ---

RESIDENT yes

formula doesn't work.

thanks

SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
Or you can also try this....

`=IF(OR(ISNUMBER(SEARCH({"Residence","Resident","Residential"},AK2))),AM2+3,AM2+2)`

ASKER

thank you very much.

ASKER

thanks

You're welcome.

@Subodh Tiwari (Neeraj)...Thumbs Up ....this is how i learnt .....Thanks

@ Wass_QA mine formula wont work for your all condition.

@ Wass_QA mine formula wont work for your all condition.

@itjockey

Glad you found it helpful. :)

Glad you found it helpful. :)

Don't know if this would have helped but your original formula had incorrect character lengths for two of the options:

LEFT(AK2,

LEFT(AK2,

LEFT(AK2,

LEFT(AK2,

**10**)="RESIDENCE" but RESIDENCE = 9LEFT(AK2,

**11**)="RESIDENTIAL" correct as RESIDENTIAL = 11LEFT(AK2,

**9**)="RESIDENT" but RESIDENT = 8
ASKER

=IF(ISERROR(FIND("RESIDENC

how do I add to the formula

RESIDENTIAL

RESIDENT