Forum Discussion

Travis78780's avatar
Travis78780
Copper Contributor
May 22, 2024

Replace #VALUE Error with Blank space

Hi all,

 

I am trying to replace a #value error with a blank space depending on the value of another cell that it is trying to calculate from.

 

For example, I am finding the percentage difference between two cells using the exact formula in K2: =IF(I2=0,IF(J2>0,"",""),(J2-I2)/I2). What I'm trying to do is, is replace the #value error with a blank like the "" is doing for my 0, and my #Div/0 errors. It seems to be if there is no entry in either I or J, but that's not 100% correct as about half of them have no issue and do not have the #value, but are blank like i would like.

 

Whats the proper formula to put in K2 to display what I want? Any help would be Awesome.

2 Replies

Resources