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},“”)
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*
@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},“”)
Your syntax is correct. I am not sure why it doesn’t work. But this seems to work: 
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.
@GCavin thanks agin…that last suggestion with multiple IFs worked!..no clue why my trys didn’t work 