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
Last edited by mdmackillop; 02-26-2006 at 08:30 AM. Reason: Title changed to make searchable
Put $ around the A3 like $A$3
That will anchor the formula to that cell.
$A3 would anchor only the column
A$3 would anchor only the row.
This is covered in the help menu under Absolute and Relative formulas.
You can also press F2 (edit mode) in the formula's cell and toggle through the settings in the formula bar by pressing F4
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
I hate it when I get stuck with something. If it were not for you guys they
would have put me in the looney tunes house. Thanks again I will rate this thread big time.
Max
No problem Max, we all get stuck in the forest and cant see the trees.
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Posting Permissions
Reply With Quote