|
awesome, I think i finally got it to work, using the If function. The formula bar looks hellish, with all the variables and stuff, ha, BUT IT WORKS!@ Thanks eveybody.
Okay, i have one other small question, when typing in formulas, if say you want to use cell A2 as a constant, so that to change the output of all the formulas, you only have to change A2, how to do you keep that cell constant in the formula when you copy the formula to other cells. So for instance, if i drag the formula to the cell below it, instead of using A2 as a referce, it will change to B2. seems to me i used to use a $ sign in front of the constant cell in school, but here at home that doesnt seem to work, I am using excel 2000 by the way if that makes a difference. Thanks again for the help!
Justin
|