Action List Based on Yes/No answers.

**emmarky** · 11-26-2010, 07:32 PM

Hello.

I can use the IF function to create text based on a number being present but I cannot get the IF function to display text dependant on text being present.

Can someone tell me the (no doubt obvious) formula for this scenario.

If Sheet 1, A 2 contains a "Yes" I want Sheet 2, A 2 to state "The M.I.D on this site currently has a Spyder Mast installed and will need to be decomissioned by Spyder in conjunction with the network boost to maintain the signal" If it contains a "No" I want stated "No action required"

Sorry, even the Dummies guide isn't simple enough for some!

**shg** · 11-26-2010, 07:35 PM

=if(sheet1!a2="Yes", "The MID ...", "No action required")

**Richard Buttrey** · 11-26-2010, 07:36 PM

Hi,

=IF(Sheet1!A2="Yes","your long text","No Action required")

Note 'Sheet1' is the name of the sheet - change as necessary

Rgds

**emmarky** · 11-27-2010, 05:53 PM

Thanks guys,
That's good enough for me. I can get it to work if I manually insert your code but using the "sum if" pop up box in my excel it does not insert the same code and fails.

I have enough info to work out why now though,

Many thanks and sorry to trouble you "again" with such minor problems.