#VALUE! error value remover

[Manoj K]

I have values in two cells and would like to get actual difference figure in column ‘C’.

Column ‘A’ figure is from formula =IFERROR(VLOOKUP(C13,'Budget 2021-22'!$D:$N,11,FALSE), " ")

Column ‘B’ is also from formula =IFERROR(VLOOKUP(C6,'Apr 2022'!$B$3:I50,8,FALSE), " ").

If column ‘B’ is blank I am getting #VALUE! Error in column ‘C’. I would like to get blank cell in column ‘C’. Please help

 

[FormR]

Hi, I would suggest you change your column A & B formulas so they return a zero length string instead of a space in the event of an error. So..

=IFERROR(VLOOKUP(C13,'Budget 2021-22'!$D:$N,11,FALSE),"")

=IFERROR(VLOOKUP(C6,'Apr 2022'!$B$3:I50,8,FALSE),"")

Then in column C you can use.

=IF(B2="","",B2-A2)

 

[Manoj K]

Hi, I would suggest you change your column A & B formulas so they return a zero length string instead of a space in the event of an error. So..

=IFERROR(VLOOKUP(C13,'Budget 2021-22'!$D:$N,11,FALSE),"")

=IFERROR(VLOOKUP(C6,'Apr 2022'!$B$3:I50,8,FALSE),"")

Then in column C you can use.

=IF(B2="","",B2-A2)

it worked, but column A2 is blank B2 is having figures, it gives error. Please help for that also.

 

[FormR]

Hi, you can try:

=IF(OR(A2="",B2=""),"",B2-A2)