Home |
Search |
Today's Posts |
#1
|
|||
|
|||
=f14-(f14*$e$15)
Hi all,
Some one assit me what is the meaning of *$E$15? Regards, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
=f14-(f14*$e$15)
Multiply by E15
The reason for the $ signs is to make E15 an absolute cell reference. See help on relative and absolute reference. Gord On Fri, 20 Apr 2012 10:12:03 +0000, sftaa wrote: Hi all, Some one assit me what is the meaning of *$E$15? Regards, |
#3
|
|||
|
|||
The formula will give you the result of multiplying the number in cell F14 by the number in cell E15 and subtracting that number from the one in F14.
The $'s in the formula mean when you copy the formula to other rows it will still look at the figure in E15 rather than changing it. Note that F14 will change to F16 then F17 etc. but E15 will remain. Hope that makes sense. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|