Can anyone review this IF Statement for me?

  C_H3X 09:26 21 Feb 2018

I need it to auto-fill column G with a different outcome based on what is selected in a drop-down list in column F.

=IF(F2="Doesn't like deVere", "Had a bad experience? - Bad pint/still go to the pub", " "), IF(F2="Called all the time", "Who did you sit down with", " "), IF(F2="Why should I use deVere?", "People are unaware of their options/We are independent/Uniques products", " "), IF(F2="No Money", "More reason/Quality of life vs Retirement Planning/No tax=min 20% salary increase - vital to start now", " "), IF(F2="Has a financial adviser already", "Good - serious about finances/preferable for us/independent/unique products", " "), IF (F2=Leaving the UAE, "More pressing/Taxes on Exit", " "), IF(F2="Wants to invest in property", "Wise/part of every portfolio/2008 housing crash/Diversified portfolio - risk spreading/cash/bonds/equity/property", " ")

  Forum Editor 11:21 21 Feb 2018

I'm afraid we don't provide free IT advice for commercial use.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy Book 2: Release date, price and specs

This First Man soundtrack vinyl cover art is exquisitely composed

How to watch Apple’s October 2018 iPad launch

Meilleurs VPN (2018)