Multiplying Formula Issue

I am looking to multiply a simple "quantity" times the "cost each" into a third cell. I created a formula but cells that have no entries in the quantity and cost cells yet, have totals as $0.00 in this column. I played around with the IF statement but had no luck. I do not want to see a column of zeros.

Find more posts tagged with

Project Management

Comments

Andrée Starå

Hi,

Do you want it to be blank or should there be anything else in the cell?

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Marcin P

Try this in the 3rd column:

If it has to stay blank, and if you want to put some info in there, just enter it between quotation marks.

=IF(your_cell_X * your_cell_Y = 0, "", your_cell_X * your_cell_Y)

Al W

Yes, that worked perfectly. Thank you!

Al W

Yes, I did want it to be blank.

Thanks

Andrée Starå

Happy to help!

Marcin provided a great solution below.

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Attachment/sheet size
This discussion was created from comments split from: Attachment/sheet size maximum limit.
How am I able to change timeline colors, when no color setting appears when I right click?
When I right click the only option I get is to edit and not to change the color settings, and I am looking to change the color!
Download backup
Hi, I did a backup of all my workspaces before my license expiry and got confirmation mail for the backups. I still have access to Smartsheet, but I don't see the backups done as I would like to download them. Can someone guide me on how to download the backups please?