If cell has zero entered, display zero. If cell has no value, display nothing

Asked Mar 29 '22 at 14:07

Active Mar 29 '22 at 14:13

Viewed 15 times

I have a worksheet (B) that references another worksheet (A). If a value is entered as zero (0) in (A), I need it to display a zero (0) in (B). However, if cell is blank in (A), referenced cell in (B) should also be blank.

I have tried doing the "show a zero in cells that have zero value", which isn't quite what I need. Attempted to reformat a few cells, but this has also not provided me with my desired result.

edited Mar 29 '22 at 14:13

Mark Rotteveel

100,966
191
140
197

asked Mar 29 '22 at 14:07

Angela Waszkiewicz

2

you can do an if: `=IF(SheetBlaBla!A1 = "", "",SheetBlaBla!A1)` – Scott Craner Mar 29 '22 at 14:11
2

Or if you are okay with strings: `=SheetBlaBla!A1&""` this will turn the numbers into strings, but the blanks will show an empty string. – Scott Craner Mar 29 '22 at 14:12

If cell has zero entered, display zero. If cell has no value, display nothing

0 Answers0