#VALUE error on blank cell

[Angliojoe]

Hello all,

I am currently using the following formula to track variance =IF(I18>0,(I18-I17)/ABS(I18),"")

It works fine as long as there is a value in I18 but when there isnt a value in I18 I want it to just leave a blank cell but instead I keep getting a #VALUE error. I think the problem is that there is a formula in I18 but it doesnt have a value because the formula in I18 is summing values that havent been entered yet.

How do I get the formula to recognise that the cell is blank when there is a formula but no value in it? Argh.

Please help!

Joe,

 

[Aladin Akyurek]

Hello all,

I am currently using the following formula to track variance =IF(I18>0,(I18-I17)/ABS(I18),"")

It works fine as long as there is a value in I18 but when there isnt a value in I18 I want it to just leave a blank cell but instead I keep getting a #VALUE error. I think the problem is that there is a formula in I18 but it doesnt have a value because the formula in I18 is summing values that havent been entered yet.

How do I get the formula to recognise that the cell is blank when there is a formula but no value in it? Argh.

Please help!

Joe,

Try...

=IF(ISNUMBER(1/I18),(I18-I17)/ABS(I18),"")

 

[Angliojoe]

Thanks for the input but unfortunately that gives me a #DIV/0 error? Any other ideas?

 

[Aladin Akyurek]

Thanks for the input but unfortunately that gives me a #DIV/0 error? Any other ideas?

=IF(ISNUMBER(1/I18),(I18-I17)/ABS(I18),"")

cannot give you a #DIV/0! error... What do you have in I17 and I18 when you seem to get such an arror?