Cookies help us deliver our services. By using our services, you agree to our use of cookies.
Tip: Other languages are Google-Translated. You can visit the English version of this link.
or

Register

or

# Get a number X less than anther number

• Neol Davies
• Topic Author
• Offline
• New Member
2 weeks 6 days 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
1 month 3 weeks 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.
##### Attachments:

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