IF and THEN question

[ThomasN]

Hello,

I have a spreadsheet where a certain column display what is to be done
with the information. For example:
A B C D
123 456 789 DELETE
987 654 321 ADD

What I'd like to do in column E is to make a formula that says:

If D1 equals DELETE, then put the value DEL in E1
If D1 had been ADD, then I would want the value PUT in E1

Does this make any sense?

Thanks for any help!

Thomas

 

[Frank Kabel]

Hi Thomas
put the following in E1:
=IF(D1="DELETE","DEL",IF(D1="ADD","PUT",""))
copy down

HTH
Frank

 

[Chip Pearson]

Thomas,

Try the following formula:

=IF(D1="delete","DEL",IF(D1="add","PUT",""))

 

[ThomasN]

Thanks Frank and Chip! That is exactly what I needed!!

Thomas