Why is my multiplication formula invalid?

Sophie Jaeger

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!

David Joyeuse

Hi @Sophie Jaeger

Try removing quotes around numbers. with the quotes, Smartsheet see values as text instead of numbers.

Or add the VALUE function to your other formula so those values are treated as numbers.

Hope it helped!

David Joyeuse

Hi @Sophie Jaeger

Try removing quotes around numbers. with the quotes, Smartsheet see values as text instead of numbers.

Or add the VALUE function to your other formula so those values are treated as numbers.

Hope it helped!