Multiplying Formula Issue

Al W

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å

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