ExcelBanter - =f14-(f14*$e$15)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - =f14-(f14*$e$15) (https://www.excelbanter.com/excel-discussion-misc-queries/445833-%3Df14-f14%2A%24e%2415.html)

sftaa

=f14-(f14*$e$15)

Hi all,

Some one assit me what is the meaning of *$E$15?

Regards,

Gord Dibben[_2_]

=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,

Spencer101

Quote:

Originally Posted by sftaa (Post 1601009)

Hi all,

Some one assit me what is the meaning of *$E$15?

Regards,

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.

All times are GMT +1. The time now is 07:01 PM.