Forum Discussion

Brass Contributor

Sep 01, 2022

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,,,

developer

excel

Formulas and Functions

Macros and VBA

office 365

Harun24HR
Sep 01, 2022
KAM_Mumin Use below formula.
=IF([@subRemarks]=0,"",[@subRemarks])

7 Replies

Harun24HR
Silver Contributor
Sep 01, 2022
KAM_Mumin Use below formula.
=IF([@subRemarks]=0,"",[@subRemarks])
- KAM_Mumin
  Brass Contributor
  Sep 02, 2022
  Dear Thank you very much.
  It works,,,
  - Harun24HR
    Silver Contributor
    Sep 02, 2022
    If it works then please tick mark the answer.
PeterBartholomew1
Silver Contributor
Sep 01, 2022
KAM_Mumin
It appears that you wish to achieve no more than the a column with zeros replaced by blanks?
= IF([@SubRemarks]<>0, [@SubRemarks], "")
- KAM_Mumin
  Brass Contributor
  Sep 02, 2022
  It works but showing a little fx error but works,,,PeterBartholomew1
  - PeterBartholomew1
    Silver Contributor
    Sep 02, 2022
    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.