gimli
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.
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
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