Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does this formula mean =M49*(1-$P$1)
What does this formula mean =M49*(1-$P$1)
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |