If this column is this... unless this column is this

[confusedcardiac]

Hello, I've tried pretty hard to figure this out and I am stuck. Essentially I am creating a list of patients with aortic aneurysms and the size determines when they follow up. But, if the have a bicuspid valve, the follow up date changes.

Column F has size
=IFS(F2>=4.4, "6 months",F2>=4, "12 months", F2<4,"Follow up with cardiology")
The problem is if a patient has a Bicuspid valve (which is listed in column G) and the size is 4 (F2>=4), then the patient needs follow up in 6 months instead of 12.

Also, in column E I have the first date of imaging and it would be great if, instead of 6 months, it actually gives me 6 months after the date.
Any help would be greatly appreciated, even if it is telling me it isn't possible. At least I won't keep spending so much time trying to figure it out.

 

[JoeMo]

In H2 and copy down:

=IFS(AND(F2>=4,G2="Bicuspid"),"6 months",F2>=4.4, "6 months",F2>=4, "12 months", F2<4,"Follow up with cardiology")

 

[confusedcardiac]

Thank you so much!

 

[confusedcardiac]

Seriously, I would like to pay you for this help

 

[JoeMo]

Thank you so much!

You are welcome - thanks for the reply.