View Full Version : Solved: Value Function

12-10-2010, 06:18 AM
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.

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

12-10-2010, 07:00 AM
Friday morning brain fart...

I figured out my mistake

ignore me

12-10-2010, 07:18 AM
The please mark it solved. Thanks.