MrExcel Publishing
Your One Stop for Excel Tips & Solutions

multiple if conditions


Posted by Ed Moss on December 13, 2001 9:21 AM

How can I set up a formula that will return the text string (my Column D)in the FORMULA cell, , that corresponds to a "1" placed in column E, as displayed below?

Usage? FORMULA
Daily 0
Weekly 0
2 - 3 times per month 0
1 time per month or less 1
No Response 0

Thanks!

Ed


Posted by Jacob on December 13, 2001 9:36 AM

Hi

Im not 100% sure what you want but this should get you started.
Lets assume E1 has the data we are checking.

if(E1=1,"My Column D",if(E1=0,"Something",if(E1=2,"Something else","False Value")))

Hope this helps

Jacob