Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Please help..what does this mean "=ROUND(((F8/$C$4)*($C$4-E8)),)"
|
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
abc_000 wrote:
Please help..what does this mean "=ROUND(((F8/$C$4)*($C$4-E8)),)" 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.) -- All I have in this world is my balls and my word, and I don't break 'em for no one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Round Up and Round Down Time | Excel Worksheet Functions | |||
Round up | Excel Worksheet Functions | |||
VB Function Round vs Excel function Round not behaving the same Od | Excel Programming | |||
Round Up/Down ? | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |