A
A
Alexsbr2017-11-06 12:12:04
excel
Alexsbr, 2017-11-06 12:12:04

How to write a formula in Google spreadsheets?

Good afternoon! I ask for help on Google tables:
there is such a sign.
5a0022fbc0825990487543.jpeg
The balance column is calculated using the formula "x - the value from the Sum column".
"x" - calculated and taken from another cell. For example, x = 100.
This formula should apply to the entire Balance column.
The problem is that if there is no value in the Sum column, then this difference is still calculated in the balance column.
Therefore, the total amount is not calculated correctly.
How to make it so that if there is no value in the Sum column, then in the balance column the difference is not considered, but simply empty or at least "0" (so that the total amount is calculated correctly)
It should be like this in the end:
5a0026c674877749576223.jpeg
those. so that the value in the balance table is calculated only after the value is entered in the Sum field
. The format of all cells is "number"
thanks!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
DS28, 2017-11-06
@Alexsbr

Accidentally wrote in the comments..
ISBLANK will help you.
Use isblank(empty cell) => true as a condition for calculating the balance column . The result
will be the formula:
if(isblank(cell from the sum column);"";your formula)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question