I have 2 formulas below that are working correctly, but looking for the proper syntax to combine them with an OR
=IF((AND(U2="35 & above",U2="Critical")),A2,"")
=IF((AND(V2="7 or more days since last update",U3="Critical")),A2,"")
I was trying to do something like below but is not working
=IF((AND(U2="35 & above",U2="Critical")),OR(IF((AND(V2="7 or more days since last update",U3="Critical")),A2,"")
=IF((AND(U2="35 & above",U2="Critical")),A2,"")
=IF((AND(V2="7 or more days since last update",U3="Critical")),A2,"")
I was trying to do something like below but is not working
=IF((AND(U2="35 & above",U2="Critical")),OR(IF((AND(V2="7 or more days since last update",U3="Critical")),A2,"")