Trying to use AND & OR in IF function

ivan.fortuna2024

I keep getting Daily for all values. I want the UOM column to be Daily unless the Vendor column is US Med-Equip and over 28 or if the Vendor column is Fukuda. Otherwise, it should be Daily.

=IF(AND(Vendor@row = "US Med-Equip", Days@row >= 28, OR(Vendor@row = "Fukuda Denshi")), "Month", "Daily")

True=Month

False=Daily

ivan.fortuna2024

Figured it out! :)

=IF(OR(Vendor@row = "Fukuda", AND(Vendor@row = "US Med-Equip", Days@row >= 28)), "Month", "Daily")

ivan.fortuna2024

Figured it out! :)

=IF(OR(Vendor@row = "Fukuda", AND(Vendor@row = "US Med-Equip", Days@row >= 28)), "Month", "Daily")

Genevieve P.

Hi @ivan.fortuna2024

Thanks for posting your solution!