Multiplying Formula Issue

Al W · 10/29/18

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.

Andrée Starå · 10/29/18

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 · 10/29/18

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 · 10/29/18

Yes, that worked perfectly. Thank you!

Al W · 10/29/18

Yes, I did want it to be blank.

Thanks

Andrée Starå · 10/29/18

Happy to help!

Marcin provided a great solution below.

Best,

Andrée

Multiplying Formula Issue

Comments

Categories