Nested IF Statement

I'm fairly new to Smartsheet and  I'm trying to calculate a planned budget based on an "Assigned to" column. I'm getting unparseable, so I'm missing something. Here is what I'm trying to build if someone might help me solve the issue...

=IF([Assigned To]@row = "Bob Dole", [Planned Hr]@row * 175), IF([Assigned To]@row = "Abe Lincoln", [Planned Hr]@row * 200), and so on...))

I have a team of 8 in which 5 have different bill rates, so I would need to repeat this string to include all of them in the formula.

Thanks for the help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!