G
Guest
I am hoping that someone can help me with this problem.
I have created several named ranges in excel, I am using excel 2000. Before
anyone asks, I selected the range of cells i.e. c2 to c13, clicked in the
name box and then typed in a name.
Now what happens is when I go to do a simple formula using my named ranges I
get the #value! error message. For example I enter the formula as =gas+food
Using that format generates the error, but I know the ranges will work
because if I do the formula of =sum(gas) or =sum(gas,food) I will get the
result.
Why won't excel recogonize my formula in the format of =gas+food
I have check my options and I do have the option of use labesl in formulas
turned ON.
I am hoping someone knows how to fix this.
Thanks
I have created several named ranges in excel, I am using excel 2000. Before
anyone asks, I selected the range of cells i.e. c2 to c13, clicked in the
name box and then typed in a name.
Now what happens is when I go to do a simple formula using my named ranges I
get the #value! error message. For example I enter the formula as =gas+food
Using that format generates the error, but I know the ranges will work
because if I do the formula of =sum(gas) or =sum(gas,food) I will get the
result.
Why won't excel recogonize my formula in the format of =gas+food
I have check my options and I do have the option of use labesl in formulas
turned ON.
I am hoping someone knows how to fix this.
Thanks