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

C

Chip Pearson

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
 
J

joeu2004

Chip Pearson said:
It means subtract the value in cell P1 from 1, then
multiply that result by the value in cell M49.
Click to expand...

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.
 
Top