software

What does this formula mean =M49*(1-$P$1)

It means subtract the value in cell P1 from 1, then multiply that
result by the value in cell M49.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

quot;lance559quot; gt; wrote in message
...
gt; What does this formula mean =M49*(1-$P$1)
quot;Chip Pearsonquot; wrote:
gt; quot;lance559quot; gt; wrote:
gt; gt; What does this formula mean =M49*(1-$P$1)
gt;
gt; It means subtract the value in cell P1 from 1, then
gt; multiply that result by the value in cell M49.

I would only add that while $P$1 and M49 are both
ways of referencing a cell, $P$1 is call an quot;absolutequot;
reference, whereas M49 is a quot;relativequot; reference.
The difference arises when you copy the formula.
For example, suppose the formula above is in N49,
and you copy it to N50. M49 will change to M50, but
$P$1 will remain the same.