Simple multiplying formula question

Al W

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

Mike Wilday

Try, 

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

Andrée Starå

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

Brian W

Alternately, you could use ISBLANK.

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

Paul Newcome

Or even

 

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

Al W

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

 

Al W

Mike Wilday

You're welcome. 

Al W

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

Andrée Starå

Happy to help!

Best,

Andrée

Paul Newcome

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

Al W

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

Al W

I must not be doing something right here.

 

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

 

Thanks,

Al W

Paul Newcome

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

Paul Newcome

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

 

This SHOULD work...

Andrée Starå

Ok.

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

Did it work?

Best,

Andrée

Brittany Lucarell

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.