Forum Discussion

jofa56's avatar
jofa56
Copper Contributor
Sep 13, 2018

Removing Zeros

Hi, I have an IF formula that looks like this.

 

=IF(AND(C2="P1 & 10";H2="RUN");I2;0)

 

My problem is that I get a column that looks like

 

5

0

0

0

-2

 

and so on.

Is there a way to get rid of the zeros in the same formula?

excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Sep 13, 2018

    Hi,

     

    Please replace the zero at the end of this formula:

    =IF(AND(C2="P1 & 10";H2="RUN");I2;0)

     

    With double quotes as follows:

    =IF(AND(C2="P1 & 10";H2="RUN");I2;"")

     

    Hope that helps

Resources