CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Jamie Hutber
Jamie Hutber

Reputation: 28076

Setting a default value for the current cell Google Spreadsheets

It seems its possible to conditionally fill the value of other cells based on the value from other cell. However I would like to say, if I have not entered any information to a cell it displays a 0

=ArrayFormula(IF(ISBLANK(D2), "", 0))

or

=IF(ISBLANK(D2), "", "Default Value")

But this will return #REF! error

enter image description here

Upvotes: 1

Views: 710

Answers (2)

player0
player0

Reputation: 1

You can do this, but not directly.

For your range from the image C2:E you can do:

=ARRAYFORMULA(C2:E*1)

But this formula needs to be used in row 2 in any empty column which isn't C, D or E column. After that, you can hide the C:D columns and use visual only from the arrayformula

fuck off halfer

Upvotes: 1

javadev
javadev

Reputation: 790

You can't calculate D2 value with D2 value... You can't use D2 in the formula.

a better approach will be having another column (E2) that will be defined by:

E2 formula:
=IF(ISBLANK(D2), "", "Default Value")

Upvotes: 0

Related Questions