Tenspeed39355
02-26-2006, 06:58 AM
Good morning guys. I am stuck. I have tried all I know which is a little to slove the problem. Here is the problem. I am using Excel ss. I am using a formula using the IF statement. The is the first part of the IF statement.
=IF(A3="YES","Buy","No"). I want to use that same formula in the next several cells. When I do a copy, paste or paste special in the next cell the
formula changes from A3 to B3. How do I keep the formual from changing?
I have tried alll I know so can you help??
Thanks
Max:bow:
=IF(A3="YES","Buy","No"). I want to use that same formula in the next several cells. When I do a copy, paste or paste special in the next cell the
formula changes from A3 to B3. How do I keep the formual from changing?
I have tried alll I know so can you help??
Thanks
Max:bow: