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
- 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.
- You are right that works,, thank you for supporting me,,, Dear I have also another post plz see that if you have the solution,,,,!
