Nesting Formula for RYGB

raymond.j.riosiii94806

Can anyone help me with a nested formula:

I need the date to populate if the RYGB is yellow or red only.

Formula works for one if I "not" green, but I want it to be if not green or not blue: =IF([Exposure Category]2 <> "Green", [Last Date of Exposure]2 + 15, "N/A")

Can anyone help?

Paul Newcome

My apologies. It should have been an AND instead of an OR.

=IF(AND([Exposure Category]2 <> "Green", [Exposure Category]2 <> "Blue"), [Last Date of Exposure]2 + 15, "N/A")

Paul Newcome

Try this...

=IF(OR([Exposure Category]2 <> "Green", [Exposure Category]2 <> "Blue"), [Last Date of Exposure]2 + 15, "N/A")

raymond.j.riosiii94806

Hi Paul, no it did not work... noticed that with this new formula you proposed, it doesn't error, but doesn't change based on any RYGB color change either.

Paul Newcome

My apologies. It should have been an AND instead of an OR.

=IF(AND([Exposure Category]2 <> "Green", [Exposure Category]2 <> "Blue"), [Last Date of Exposure]2 + 15, "N/A")

raymond.j.riosiii94806

Perfect, it worked! Thanks Paul!

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response as "helpful" so that others searching for a similar solution can know that one may be found here.