Excel formula difference between two numbers
Solved
rafiot689
-
rafiot689 -
rafiot689 -
Hello,
I am reaching out to you because I am currently using a spreadsheet and I am looking for a formula that I have used before but cannot remember.
I have the number 78.3 in a cell to the left and, 50 cells later, I have the number 75. I need a formula that will calculate the decreasing linear difference between the two values compared, 78.3 and 75, taking into account the 50 cells filled in. P.S.: My vocabulary doesn’t use exact terms; I’m just trying to make myself understood!
Thank you in advance.
Best regards.
I am reaching out to you because I am currently using a spreadsheet and I am looking for a formula that I have used before but cannot remember.
I have the number 78.3 in a cell to the left and, 50 cells later, I have the number 75. I need a formula that will calculate the decreasing linear difference between the two values compared, 78.3 and 75, taking into account the 50 cells filled in. P.S.: My vocabulary doesn’t use exact terms; I’m just trying to make myself understood!
Thank you in advance.
Best regards.
Configuration: Windows Vista Firefox 3.0.3
9 réponses
One solution among others...
In any cell.. =(C10-C28)/ROWS(C11:C27)
C10=The highest number
C28=the lowest
Row matrix = between the two numbers
and in the cells between these two numbers.. =C10-$D$10 to pull down the range where we want the result.
It works, I've tested it.
See you later
--
Experience teaches more surely than advice. (André Gide)
If you bump into a pot and it sounds hollow, it's not necessarily the pot that's empty. ;-)(Confucius)
In any cell.. =(C10-C28)/ROWS(C11:C27)
C10=The highest number
C28=the lowest
Row matrix = between the two numbers
and in the cells between these two numbers.. =C10-$D$10 to pull down the range where we want the result.
It works, I've tested it.
See you later
--
Experience teaches more surely than advice. (André Gide)
If you bump into a pot and it sounds hollow, it's not necessarily the pot that's empty. ;-)(Confucius)
