4 different types of logic

Chris in NC

New Member
Joined
Sep 13, 2006
Messages
2
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.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,870
Hi Chris
Welcome to the board

Please try

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

Hope this helps
PGC
 

Watch MrExcel Video

Forum statistics

Threads
1,112,885
Messages
5,543,033
Members
410,583
Latest member
gazz57
Top