=IF (Either) formula | Multiple IF Statement

[clprdctn]

Hello,

I'm trying to write a formula to say below all in one:

=IF 'AD2' says 'cancelled' then current selected cell = $90.00
=IF 'AD2' says 'drive by' then current selected cell = $200.00
=IF 'AD2' says 'full ap' then current selected cell = $300.00
=IF 'AD2' says 'RPM' then current selected cell = $750.00
=IF 'AD2' says 'Ap Up' then current selected cell = $150.00


Your help is greatly appreciated.

[AZ-XL]

Hi
If you will prefer if function formula will be long. Try this
=VLOOKUP(AD1,{"Cancelled",90;"Drive by",200;"Full Up",300;"RPM",750;"Ap Up",150},2,0)

[clprdctn]

Thank you AZ-XL. But now what can i add to that, to say - if none leave it blank ""?

[AZ-XL]

You can add iferror function
=IFERROR(VLOOKUP(AD1,{"Cancelled",90;"Drive by",200;"Full Up",300;"RPM",750;"Ap Up",150},2,0),"")

it will give you blank cell if the cell (ad1) is blank or other than listed criterias.

[clprdctn]

1 Last question:

How would you write this to say if none leave it blank ""?

=IF(ISTEXT(VLOOKUP(F2,$AJ$2:$AJ$12,1)),"MMS","Retail")

[AZ-XL]

1 Last question:

How would you write this to say if none leave it blank ""?

=IF(ISTEXT(VLOOKUP(F2,$AJ$2:$AJ$12,1)),"MMS","Retail")

Do you mean this?
=iferror(IF(ISTEXT(VLOOKUP(F2,$AJ$2:$AJ$12,1)),"MMS","Retail"),"")

[clprdctn]

Actually, I figured it out:

=IF(F2="","",IF(ISTEXT(VLOOKUP(F2,$AH$2:$AH$12,1)),"MMS","Retail"))