IF OR help, please
I have a column (Project ID), with multiple values and a column (Bill Rate) that needs to be populated based on the value in Project ID.
I need to screen Project ID for two (2) specific entries, "NRM Logistics" and NRM-0418 Logistics" and have Bill Rate populated with "Rate5" if either of these are found or Rate2 for everything else.
This formula is not working. Where am I off track?
=IF(OR([Project ID]89 = "NRM Logistics", [Project ID]89 = "NRM-0418 Logistics", "Rate5", "Rate2"))
Help Article Resources
Check out the Formula Handbook template!