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

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

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

"lance559" wrote in message
...
What does this formula mean =M49*(1-$P$1)

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

"Chip Pearson" wrote:
"lance559" wrote:
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.

I would only add that while $P$1 and M49 are both
ways of referencing a cell, $P$1 is call an "absolute"
reference, whereas M49 is a "relative" 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.