Link to home
Start Free TrialLog in
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



Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

where you you get 9 from?  3 -4 = -1
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
same here here is what I seeUser generated image
Avatar of ADRIANA P

ASKER

 David Johnson  Welcome and thank you for participating
like Martin Explain

but any question you are welcome
My result in S6 does not agree with your picture. 
you are right
Great Job ! Great Expert !