=f14-(f14*$e$15)

G

Gord Dibben

Multiply by E15

The reason for the $ signs is to make E15 an absolute cell reference.

See help on relative and absolute reference.


Gord
 
S

Spencer101

sftaa;1601009 said:
Hi all,

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

Regards,
Click to expand...

The formula will give you the result of multiplying the number in cel
F14 by the number in cell E15 and subtracting that number from the on
in F14.

The $'s in the formula mean when you copy the formula to other rows i
will still look at the figure in E15 rather than changing it. Note tha
F14 will change to F16 then F17 etc. but E15 will remain.

Hope that makes sense
 
Top