=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statment more than 7 stacked ? 4
Apply Conditional Formatting If Data in More Than 1 Cell Matches 5
IF function 3
how to use Solver in Excel VBA 1
Assistance in modifying a formula 0
Conditional Formatting - Excel 2003 2
Complex Formula question 9
Rounding up totals. 6

Top