Welcome!

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

Thanks.

Find more posts tagged with

Formulas

Comments

unknown

This content has been removed.

rjudenberg

close parentheses in the wrong place. try...

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

Sign in to join the conversation!

Quick Links

Trending discussions

Changes with predecessors
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Formatting Issues with Index-Collect Formula
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
Find and Replace menu
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?