How to create an If(Or formula for set of data?

[cmitchell]

I need help creating a formula for a worksheet I need for work. Listed below are the colums I will be working with.

1. Insurance
2. Initial Evaluation Date
3. Re-registration Date
4. Prescription Expiration Date

This is what I need. If column "1" says either "Medicare" or "Medicaid", then add 30 days to the date that's in column "2" and reflect that new date in column "3" , but if column "1" dosen't say "Medicare" or Medicaid" then add 90 days to the date in column "2" and reflect that date in column "3".

[shg]

Please read the Forum Rules about thread titles, and then edit the title of your post to be descriptive of your problem.

[dominicb]

Good morning cmitchell

...and welcome to the forum!!

Assuming "column 1" is A, "column 2" is B etc ...
=IF(OR(A1="medicaid",A1="medicare"),B1+30,B1+90)

Just make sure that column C is formatted as dates.

HTH

DominicB

[cmitchell]

Thank you, Thank you for your assistance, the formula worked perfectly. I didn't know such a website existed I am very happy I found it. I will be sure to share this with my friends & co-workers.

[cmitchell]

Dominic,
with the formula you sent me I realized that the 30 or 90 days added to the date in the formula needed to be 30 or 90 business days, I dont want Saturday or Sunday to be counted. Is that at all possible?

[dominicb]

Hi cmitchell

Try this :

=IF(OR(A1="medicaid",A1="medicare"),WORKDAY(B1,30),WORKDAY(B1,90))

The Workday formula is only available in the Analysis Toolpak add-in, so this will need invoking first, or you'll get the #VALUE error.
(Tools > Add-Ins, tick the Analysis Toolpak box and click OK).

HTH

DominicB