Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Get a number X less than anther number

  • Neol Davies
  • Topic Author
  • Offline
  • New Member
  • Новите държави
More
2 months 4 weeks ago #1391 by Neol Davies
Replied by Neol Davies on topic Get a number X less than anther number
Perhaps someone could direct me to somewhere I might find an answer?

Thanks. : Сигурни:

Please Log in or Create an account to join the conversation.

  • Neol Davies
  • Topic Author
  • Offline
  • New Member
  • Новите държави
More
4 months 2 days ago #1319 by Neol Davies
Get a number X less than anther number was created by Neol Davies
Hello & thanks for looking at least this far.


<<<--- Pic 2
In pic 2 ^^^ you can see a list of numbers in column "AF", these numbers are ten lower than the numbers in pic 1 (Column "N"). So in pic 1, the number on the top row is 6.4 and on the top row of pic 2 the number is 5.2 - 10 lower than 6.4 on my database list in pic 3. If you look at pic 3, you'll see that 6.4 is at the top in column A row 160. Ten lower than this is column A row 170, which shows 5.2.

<<<--- Pic 1


<<<--- Pic 3


So, what I want to do is find a formula to pull the number from (pic 3) ^^^ Column A row, that is X lower, in this case 10 lower, than the numbers in pic 1. To clarify, I type the number 6.4 in column "N", I want the number ten lower than 6.4 from column A in pic3 to automatically go in the corresponding row in colmn "AF" (pic 2).

I hope that's clear enough & thanks once again for looking at least this far. :)

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo