Blank zero's for a duplicate column formula

Platform discussions
1

This may seem redundant but I want a duplicate column to show me the same numbers from a different column which I can do, however, I want the cells to be blank if there’s no number in it??

I tried many variations of this even w/o the “IF” and I can get my numbers I just don’t want the zero’s for the empty cells??

Thanks!

IF({COLUMN-A}<>0,{COLUMN-A},“”)

2

Hi Rich,

Try

IF({COLUMN-A}>0,{COLUMN-A},"")

Want to get rid of the formula column? and write formulas that support multiple lines, variables and can update various columns at once? Take a look at the Advanced Formula Booster at https://mdboosters.com*

3

@GCavin thanks…yes, it worked with the >0, however, how can also include negative numbers? I tried this <>0 and it didn’t work…sorry i don’t remember the proper syntax for both below and above zero…

IF({Column-A}<>0,{Column-A},“”)

4

Your syntax is correct. I am not sure why it doesn’t work. But this seems to work: :thinking:

IF({Numbers}>0,{Numbers},IF({Numbers}<0,{Numbers},""))

Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.

5

@GCavin thanks agin…that last suggestion with multiple IFs worked!..no clue why my trys didn’t work :+1: