+ Reply to Thread
Results 1 to 7 of 7

Help with working out a formula for a transpoing rule

  1. #1
    Registered User
    Join Date
    05-22-2013
    Location
    Uk
    MS-Off Ver
    Excel 2007
    Posts
    5

    Help with working out a formula for a transpoing rule

    having trouble with formula for last column ( Axis) the maximum value of the Axis can only be 180. If 100 degrees is added then the value will be 80.



    I have steps 1 and 2 which are simple adding formula but I cant work out the formula for step 3 as shown below



    Transpose -3.00 +2.00 x 30
    Sphere Cylinder Axis
    -3.00 +2.00 30



    Step 1 Add the sphere and cylinder powers to determine the new sphere power

    (-3.00) + (+2.00) = -1.00



    Step 2 Change the sign of the cylinder -2.00



    Step 3 Change the axis by 90 degrees. (if the axis is 90 or less than 90, add 90 degrees to the axis, if the axis is greater than 90 deduct 90 from the axis) 120 ( this is the step I have having most problem with as the axis can only be 1- 180 , there is no zero as that would be the same as 180)



    The transposed prescription is: -1.00 -2.00 x 120
    Sphere Cylinder Axis
    -1.00 -2.00 120

    Any help how I can use a formula for step 3 or a macro function to switch back and fourth between the transposed prescription . Thanks you

  2. #2
    Registered User
    Join Date
    04-22-2013
    Location
    The Netherlands
    MS-Off Ver
    Excel 2003/2007 & 2010
    Posts
    90

    Re: Help with working out a formula for a transpoing rule

    If you attach an example workbook that would help..surely must be possible using basic formula's..

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Help with working out a formula for a transpoing rule

    Hi and welcome to the forum

    Im not really sure what you are trying to do, but assuming your axis is in A1, maybe something like this in B1?

    =if(A1<90,A!+90,A1-90)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    05-22-2013
    Location
    Uk
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Help with working out a formula for a transpoing rule

    Hello thanks for the response's ,
    I have attached a workbook to try and explain what I mean In a little more detail,
    As you can tell I am relatively new to excel but I've done the best I can
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-22-2013
    Location
    Uk
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Help with working out a formula for a transpoing rule

    Thank you - that formula does work. When I put the value 90 in A1 the B1 ends up as 0 , is there a way that instead of being 0 it ends up as 180 instead? As I cant use 0 as a value.

  6. #6
    Registered User
    Join Date
    05-22-2013
    Location
    Uk
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Help with working out a formula for a transpoing rule

    Quote Originally Posted by FDibbins View Post
    Hi and welcome to the forum

    Im not really sure what you are trying to do, but assuming your axis is in A1, maybe something like this in B1?

    =if(A1<90,A!+90,A1-90)

    Thank you - that formula does work. When I put the value 90 in A1 the B1 ends up as 0 , is there a way that instead of being 0 it ends up as 180 instead? As I cant use 0 as a value.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Help with working out a formula for a transpoing rule

    =if(A1<=90,A1+90,A1-90)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1