# Simple multiplying formula question

edited 12/09/19

I am looking for a simple formula to multiply [Quantity] times [Cost] only if there is data in the quantity cell. Currently the [total] column fills with \$0.00 if there is no data in these columns. The "HELP" page is not clear to me on how to do the ISN'T Blank formula.

Thank you

Al W

Tags:
«1

• ✭✭✭✭✭✭

Try,

=IF(Quantity@row = "", "", Quantity@row * Cost@row)

• ✭✭✭✭✭✭

Hi Al,

Try this.

=IF(Quantity@row = ""; ""; Quantity@row * Cost@row)

The same version but with the below changes for your and others convenience.

=IF(Quantity@row = "", "", Quantity@row * Cost@row)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭

Alternately, you could use ISBLANK.

=IF(ISBLANK(Quantity@row), "", Quantity@row * Cost@row)

• ✭✭✭✭✭✭

Or even

=IF(ISNUMBER(Quantity@row), Quantity@row * Cost@row)

• Thank you everyone for the quick response. Really a big help!

Al W

• ✭✭✭✭✭✭

You're welcome.

• Here what I entered on this one for row 10. I got an error. Perhaps I misunderstood your answer.

=IF(ISNUMBER([Quantity]10), [Quantity]10 * [Material Cost Each]10

Al W

• ✭✭✭✭✭✭

Happy to help!

Best,

Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

What error did you get? Other than the last parenthesis missing (which Smartsheet should have autopopulated anyway), everything looks fine.

• I got the #UNPARSEABLE error. I did add the last parenthesis because it did not do it automatically.

I will also try some of the other ideas presented.

=IF(ISNUMBER([Quantity]10), [Quantity]10 * [Material Cost Each]10)  for line 10

Thanks

Al W

• I must not be doing something right here.

=IF(([Quantity]12) = ""; ""; ([Quantity]12 * [Material Cost Each]12))

Thanks,

Al W

• ✭✭✭✭✭✭
• ✭✭✭✭✭✭

=IF(ISNUMBER(Quantity10), Quantity10 * [Material Cost Each]10)

This SHOULD work...

• ✭✭✭✭✭✭

Ok.

Try and copy my formula and then update the column names.

Did it work?

Best,

Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Hi-

I tried copying the formula =IF(Qty@row = "", "", Qty@row * Unit Cost@row) and I am still getting an #Unparseable error. Can someone please assist. I am trying to get the Total amount to fill in with the above formula.