Solved: Value Function

[gimli]

Hi all,

Im trying to use the value function in a formula and wont seem to work. I can pull a value from a string in one cell and then reference it in another and it works but not in the same formula.
ex

I7 = ABC-0200Z
I8 = VALUE(MID(I7,5,4))

This pulls the value of 200. I can reference I8 from another cell and use it in a calculation.

What I want to do is use it in a formula.

=IF(VALUE(MID(I7,5,4)=200),1,2) but i get a #value!. It seems like the value function used in a formula wont actually treat the result as a number.

Any ideas?

thanks much

[gimli]

Friday morning brain fart...

I figured out my mistake

ignore me

[austenr]

The please mark it solved. Thanks.