Avatar of ADRIANA P
ADRIANA PFlag for United States of America asked on

subtract in each digit for an 3 Digit from 3N F

3n Calculator to add 3D

29225298a 3n calculator TO ADJUST FOR 3D.xlsm


1-Adjust to SUBTRACT to each digit on sheet 3N


set this file to subtract from each digit -4 -3 - 2 -1
to numbers in N6 to N17

this time it is a 3 digit number previously it was 2 digits in2n Sheet

example

    5 4 3
   -4 -4 -4
___________
    1 0 9 = 901 in ORD



Open in new window



Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
David Johnson, CD

where you you get 9 from?  3 -4 = -1
ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Martin Liss

David, Adrianna uses a numeric ordering system where the order of numbers need to be in 2, 4, 6, 8, 0, 1, 3, 5, 7, 9 order.  For example a number like 3260 is converted to 2603.
David Johnson, CD

same here here is what I seeScreenshot-2021-10-02-092547.png
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
ADRIANA P

 David Johnson  Welcome and thank you for participating
like Martin Explain

but any question you are welcome
ASKER
ADRIANA P

My result in S6 does not agree with your picture. 
you are right
ASKER
ADRIANA P

Great Job ! Great Expert !
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.