Forum Discussion
Travis78780
May 22, 2024Copper Contributor
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
- Riny_van_EekelenPlatinum Contributor
Travis78780 Would this work?
=IFERROR((J2-I2)/I2,"")
- Travis78780Copper ContributorThat breaks my actual working percentage calculations. However, that led me to:
=IFERROR(IF(I2=0,IF(J2>0,"",""),(J2-I2)/I2),"")