Forum Discussion
Solved
MS Excel IF formula.
Hi Everyone, I want to put the cell values on the right column name Remarks from the left column name SubRemarks. But there I can only done that where the values are 0 of SubRemarks column then it s...
It appears that you wish to achieve no more than the a column with zeros replaced by blanks?
= IF([@SubRemarks]<>0, [@SubRemarks], "")
It works but showing a little fx error but works,,,PeterBartholomew1