Nested IF Statement-, it should be blank.

**FM1** · 02-10-2009, 06:42 AM

Hey everyone. I need some help on a nested IF statement.

In column A, I have the following values:
build
chil rat
datcen
mang
nextg
ost rat
omp
sco rat

In column B, I need the formula so it shows values that if column A = "build", "nextg" or "datcen", then the value in column B is "nextg" and if column A = "chil rat", "ost rat", "sco rat", then the value in column B is "mig". For everything else, it should be blank.

Thanks in advance.

**sweep** · 02-10-2009, 06:49 AM

Hi,

Can you give this a try?

Please Login or Register  to view this content.

**DonkeyOte** · 02-10-2009, 06:51 AM

Perhaps:

Please Login or Register  to view this content.

If this is full repertoire of values than you could adjust the 2nd test to look for RIGHT(A1,4)=" rat" rather than use the OR.

EDIT: The above is only a slight variant on sweep's formula... I used TRIM as when I pasted your values there were trailing spaces so this may/may not be required.

**Rahul Nagar** · 02-10-2009, 06:52 AM

Hello

you can use following formula

=IF(A1="build","nextg",IF(A1="datcen","nextg",IF(A1="chil rat","mig",IF(A1="ost rat","mig",IF(A1="sco rat","mig",0)))))

i think this might be help.

**FM1** · 02-10-2009, 06:58 AM

Both formulas worked perfectly Sweep and Donkey. Thaks again guys. Third time you guys have helped me out on this forum. Reputation added.

**FM1** · 02-10-2009, 07:01 AM

Originally Posted by Rahul Nagar

Hello

you can use following formula

=IF(A1="build","nextg",IF(A1="datcen","nextg",IF(A1="chil rat","mig",IF(A1="ost rat","mig",IF(A1="sco rat","mig",0)))))

i think this might be help.

Thanks Rahul. The two formulas above have worked so Ill just stick to them.

Cheers.