=sum(B7+C8)-$A$40
Regards,
Peo Sjoblom
"JComer" wrote:
While working in Excel, how do you keep some of the formula constant while
copying and pasting? For example, when copying the formula =sum(B7+C8)-A40
from one cell to another, how do you keep the A40 constant so that no matter
what cell it is in it will always subtract A40?
|