Formula to reference one column based on entries from another column.

Formula to reference one column based on entries from another column.

Linda FLinda F
edited 05/22/20 in Formulas and Functions

I need help on a formula for Project Assignment when a dollar amount is what determines who gets a Project assignment.

For example,

A Facilities coordinator will get a project if it falls between $5k - $24,999

Project Manager A will get a project if it falls between $25k and $99,999

Project Manager B will get a project if it falls between $100k and over

My attempt at creating the formula is below

=IF([Estimated Budget]@row = "Estimated Budget is between 5000 and 24999", "blue", IF(Estimated [email protected] = "Estimated Budget is between 25000 and 100000", "green", IF(Estimated [email protected] = "Estimated Budget is greater than 100000", "Pink")))


Best Answers

  • Linda FLinda F
    Accepted Answer

    It worked, thank you so much !

Answers

Sign In or Register to comment.