# Blank cells not working as zero (0) in Math column

Hi folks,

Working with Math column to create a simple Sum I discovered this rare problem when some cells are blank (empty). My formula is:
`Total= Qty1*Price1+ Qty2*Price2+ Qty3*Price3`

Everything is fine when all cells have some value but, if there is (are) some blank cell(s) in the formula, the result is completely crazy and funny. See my screenshot please

The workaround could be to use the What-If-Else tool but I will have to create more new columns and the APP would load more unnecessary data for this issue. My real APP and formula has 16 tags (variables) and donâ€™t want to create these dummy variables by this bug.

Thanks in advance for the help and patch!

Saludos

Sooo empty columns are considered a â€śneutralâ€ť value. Effectively neutral * X == X and neutral + X == X.

To get what you want you could change your formula to (Qty1+0)*Price1 + (Qty2+0)*Price2 + (Qty3+0)*Price3

No yet @Jason, the same wrong results are shown!

I supposed your solution days ago but it didnâ€™t work for me. I tested:

`````` 1) (Q1*P1)*1+ (Q2*P2)*1+ (Q3*P3)*1`
2) (1*Q1)*P1+ Q2*(1*P2)+ (1*Q3)*(1*P3)`
3) (0+Q1)*(0+P1)+ (0+Q2)*(0+P2)+ (0+Q3)*(0+P3)`
``````

but no luck!.. another tip?

Gracias de nuevo

Let me get with the math column guru and see what gives.

1 Like

This is a great option. You could also use an array formula in your spreadsheet to perform the same task.

Yes, I know it can be done in my GS but I wanted to perform in Data Editor to improve APP speed to users.

Saludos

I believe weâ€™re doing the wrong thing here. The default for multiplication shouldnâ€™t be `1`. Weâ€™ll fix that.

What you can do right now if you donâ€™t want to wait is to make an If-Then-Else column for quantity, like this:

`IF Quantity is empty THEN 0 ELSE Quantity`

1 Like

Gracias @Mark

How much will you last to fix it? I can wait 1-2 days more.
Iâ€™d rather this than create 16 new IF-Then-Else columns and complicate my APP. I try to keep it light and simple.

Bye

The earliest itâ€™ll land is Thursday.

1 Like

Thanks @Mark, now the rocket is fine!!

Saludos

1 Like

Hi @Mark and @Jason

I think we have an original problemâ€™s new brother here:

If I try to sum these columns and some ones are empty (blank), the result is wrong

`Qt1*Pr1 + Qt2*Pr2 + 1`

this example can guide you to understand the cases with problems:

the trick works:

IF {MyColumn} is empty THEN 0 ELSE {MyColumn}

but I have more than 10 columns and donÂ´t want to duplicate these data dummy every time I find this case. Can it can be fixed and avoid the workaround?

Thanks!

Feliz dĂ­a.

What is it youâ€™re actually trying to do here, and whatâ€™s the result you expect?

something like this Mark:

In my case, the formula doesnâ€™t sum +1

Gracias!

That might be the right thing in your case, but wrong in others. Maybe Glide is trying to be a little too smart here.

In any case, a hack that works right now is to write `1` as, for example `1*1`.