Why is my multiplication formula invalid?


I am trying to create a column that multiplies the total hours by the pay rate of certain staff.

In the pay rate column I have used the formula =IF(Name1 = "Sophie", "25.54", IF(Name1 = "Peta", "55", IF(Name1 = "Stephen", "55")))

This formula works well, however if I then try to use those values in another formula is just says "#INVALID OPERATION"

Please help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!