Having a problem not displaying #VALUE! 1

[TonyU]

Dreamboat provided me with this code which is working, Except when I made a minor change

=IF(OR(ISBLANK(I2),ISBLANK(I2)),"",I4/2)

Here's the scenario

I2 = $48.00 and is the result of a calculation On
J2 I have this formula =IF(OR(ISBLANK(I2),ISBLANK(I2)),"",I2/2) which is giving me 1/2 of I2

If I copy the formula on J2 down to J43, the values for J3 down to J43 display #VALUE!, then when I insert =(j2:J43) into J44 I get #VALUE!


Sorry if I'm not explaining myself.

^{There's never time to do it right, but there's always time to do it over!}

-TonyU

 

[Dreamboat]

#VALUE?

What's in I3?

Anne Troy
Way cool stuff:

http://www.cafeshops.com/OfficeExperts

 

[TonyU]

right now is blank

^{There's never time to do it right, but there's always time to do it over!}

-TonyU

 

[Dreamboat]

I don't think it's blank.
If you have a formula in it, it's not blank.

Anyway, if you don't want to get ANY errors (which isn't always the best, but probably okay for you), you can use (just like isblank):

=IF(ISERROR(

So...

=IF(iserror(I2/2),"",I2/2)

Anne Troy
Way cool stuff:

http://www.cafeshops.com/OfficeExperts

 

[TonyU]

You right, I have =IF(OR(ISBLANK(E3),ISBLANK(H3)),"",E3*H3) on I3

Let me try your last suggestion

^{There's never time to do it right, but there's always time to do it over!}

-TonyU

 

[TonyU]

Dreamboat, I just used this formula and it seem to be working from J2 to J43 and I no longer display #VALUE!


Thanks again

^{There's never time to do it right, but there's always time to do it over!}

-TonyU

 

[TonyU]

=IF(I2="","",I2/2)

^{There's never time to do it right, but there's always time to do it over!}

-TonyU