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