What does this mean'=ROUND(((F8/$C$4)*($C$4-E8)),)'

A

Auric__

abc_000 said:
Please help..what does this mean "=ROUND(((F8/$C$4)*($C$4-E8)),)"
Click to expand...

The data in F8 (the address of which might change) will be divided by the
data in C4 (the address of which will *never* change). The result is
multipled by the result of C4-E8 (address of E8 might change, C4 will again
never change). That result is rounded off to the nearest whole number
(integer).

(When I say "the address might change", Excel will automagically change the
address of F8 & E8 if cells above or to the left of them are inserted or
deleted, or if the formula is copied to a different cell. Adding $ before a
column ($C) or row ($4) prevents that from happening.)
 

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

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Adding sequence numbers to paragraphs 0
Cell Referencing 5
numbers, text 1
Basing math on duplicate entries in a formula 1
A Percentile IF function 1
Add and subract Time 1
Multiple If Statements 3

Top