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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top