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 shows empty cell in the Remarks column but can't showing where it gets value like as any text or any words that means without only 0 then it need to show that value in the right column. Plz if any of you know how to solve this easy problem then plz reply,,,
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
- I think the warning is showing a formula entered in an unprotected cell. Formatting the cell with Lock Cell should make the warning go away. If you do not use sheet protection, it will make little difference.
