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!

Find more posts tagged with

Formulas

Support

Project Management

Accepted answers

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!

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.