IF OR help, please

jb@59069

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"))

Thanks.

rjudenberg

close parentheses in the wrong place. try...

=IF(OR([Project ID]89 = "NRM Logistics", [Project ID]89 = "NRM-0418 Logistics"), "Rate5", "Rate2")