how do i stop sort from modifing formulas in excel

T

Tom & Carol

I am having a problem with excel 2002 I have a formula =h3-h4

=h3-h5

=h3-h6
when i sort by a differant column it changes all the formulas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula is summing text and I want it to stop doing that 2
Is this possible? 4
Need Help with Sumproduct 2
Variable row groupings 3
Trying To Put IFs into a Function 3
How do I subtract a negative number from a positive number? 4
help with my if statement 3
how to get IF(OR) formula to recognize multiple cells 7

Top