4 different types of logic

[Chris in NC]

I have 4 different types of logic that I need for one formula and it will not process the information. I am trying to track items for a suspense system.

I have in one column (A1) the type of form it is (I have 4 different types of forms that require different dates of suspense). In another column (B1) I have the date it is to be presented and in another column the date it will be due to me for processing. I want the date due to me to be automatically figured out with the formula.

Column A is equal to
LOM - due to me 110 days prior to the presentation date
MSM - due to me 80 days prior to the presentation date
ARCOM - due to me 60 days prior to the presentation date
AAM - due to me 45 days prior to presentation date

I was trying to do the formula like this:
(A1="LOM", B1-110;A1="MSM",B1-80;A1"ARCOM",B1-60;A1="AAM,B1-45)

I have tried the IF, OR and AND functions and it is not working. I can do it with just one logic, but I can't add the others in.
Can anyone help me?

Thank you very much for your time.

 

[pgc01]

Hi Chris
Welcome to the board

Please try

=B1-VLOOKUP(A1,{"LOM",110;"MSM",80;"ARCOM",60;"AAM",45},2,0)

Hope this helps
PGC

 

[Chris in NC]

PGC,

You are wonderful. It worked. Thank you so much for your help.

Chris in NC