Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
brainteaser: change a value by 90 (but answer must lie between 0-180 )
Please see below ( I want to do step 3 - change a value by 90 degrees) but the answer has to be between 0 and 180 e.g. 45 becomes 90 e.g. 95 becomes 185 (but this is wrong, so SUBTRACT 90 instead) anwer is 5 ************************************************** ********************************** from http://www.usaeyes.org/faq/subjects/script.htm Minus Cylinder or Plus Cylinder Spectacle prescriptions can be written in two value sets, minus cylinder or plus cylinder, which are mutually exclusive of each other but provide the same information. As a rule, ophthalmologists write scripts in minus cylinder whereas optometrists write scripts in plus cylinder. Why these two professions cannot get together and decide on a common method of reporting refractive error is impossible to explain, but if you have ever had competing siblings in your family, you may get an idea why this has not yet occurred. To convert a minus cylinder form prescription into plus cylinder, or to convert the plus cylinder form into minus cylinder, do the following: 1) Add the sphere and cylinder powers together; this becomes the new sphere power. 2) Change the sign of the cylinder power, from minus (-) to plus (+) or from plus (+) to minus (-). 3) Change the axis value by 90°, remembering that the axis must be a number from 1 to 180. The following lens prescriptions, therefore, are equivalent and interchangeable ************************************************** ********************************** |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
brainteaser: change a value by 90 (but answer must lie between 0-180 )
Hello,
schrieb Please see below ( I want to do step 3 - change a value by 90 degrees) but the answer has to be between 0 and 180 e.g. 45 becomes 90 ? 135 ? e.g. 95 becomes 185 (but this is wrong, so SUBTRACT 90 instead) anwer is 5 try =MOD(A1+90;180) if a1 contains the original value. HTH Stefan |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
brainteaser: change a value by 90 (but answer must lie between 0-1
=mod(a1+90,180) will constrain the sum of a1 and 90 to the range of 0-180.
" wrote: Please see below ( I want to do step 3 - change a value by 90 degrees) but the answer has to be between 0 and 180 e.g. 45 becomes 90 e.g. 95 becomes 185 (but this is wrong, so SUBTRACT 90 instead) anwer is 5 ************************************************** ********************************** from http://www.usaeyes.org/faq/subjects/script.htm Minus Cylinder or Plus Cylinder Spectacle prescriptions can be written in two value sets, minus cylinder or plus cylinder, which are mutually exclusive of each other but provide the same information. As a rule, ophthalmologists write scripts in minus cylinder whereas optometrists write scripts in plus cylinder. Why these two professions cannot get together and decide on a common method of reporting refractive error is impossible to explain, but if you have ever had competing siblings in your family, you may get an idea why this has not yet occurred. To convert a minus cylinder form prescription into plus cylinder, or to convert the plus cylinder form into minus cylinder, do the following: 1) Add the sphere and cylinder powers together; this becomes the new sphere power. 2) Change the sign of the cylinder power, from minus (-) to plus (+) or from plus (+) to minus (-). 3) Change the axis value by 90°, remembering that the axis must be a number from 1 to 180. The following lens prescriptions, therefore, are equivalent and interchangeable ************************************************** ********************************** |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
brainteaser: change a value by 90 (but answer must lie between 0-1
On Tue, 15 Nov 2005 11:31:06 -0800, "bpeltzer"
wrote: =mod(a1+90,180) will constrain the sum of a1 and 90 to the range of 0-180. Actually it will constrain it to the range of 0-179. " wrote: Please see below ( I want to do step 3 - change a value by 90 degrees) but the answer has to be between 0 and 180 e.g. 45 becomes 90 e.g. 95 becomes 185 (but this is wrong, so SUBTRACT 90 instead) anwer is 5 ************************************************** ********************************** from http://www.usaeyes.org/faq/subjects/script.htm Minus Cylinder or Plus Cylinder Spectacle prescriptions can be written in two value sets, minus cylinder or plus cylinder, which are mutually exclusive of each other but provide the same information. As a rule, ophthalmologists write scripts in minus cylinder whereas optometrists write scripts in plus cylinder. Why these two professions cannot get together and decide on a common method of reporting refractive error is impossible to explain, but if you have ever had competing siblings in your family, you may get an idea why this has not yet occurred. To convert a minus cylinder form prescription into plus cylinder, or to convert the plus cylinder form into minus cylinder, do the following: 1) Add the sphere and cylinder powers together; this becomes the new sphere power. 2) Change the sign of the cylinder power, from minus (-) to plus (+) or from plus (+) to minus (-). 3) Change the axis value by 90°, remembering that the axis must be a number from 1 to 180. The following lens prescriptions, therefore, are equivalent and interchangeable ************************************************** ********************************** --ron |
#6
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
brainteaser: change a value by 90 (but answer must lie between 0-1
bpeltzer wrote: =mod(a1+90,180) will constrain the sum of a1 and 90 to the range of 0-180. Thanks you - that's excellent. but how do i contrain sum from 1 to 180 (not 0 to 180) (so 90 degrees becomes 180 instead of 0) |
#7
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
brainteaser: change a value by 90 (but answer must lie between 0-180 )
Stephan Bielicke wrote: Hello, schrieb Please see below ( I want to do step 3 - change a value by 90 degrees) but the answer has to be between 0 and 180 e.g. 45 becomes 90 ? 135 ? e.g. 95 becomes 185 (but this is wrong, so SUBTRACT 90 instead) anwer is 5 try =MOD(A1+90;180) if a1 contains the original value. HTH Stefan thanks for correcting my maths! =MOD(A1+90;180) didn't work - I replaced the semicolon ( ; ) with a comma ( , ) - you probably meant this |
#8
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
brainteaser: change a value by 90 (but answer must lie between 0-180 )
Ron Rosenfeld wrote: On 15 Nov 2005 11:11:04 -0800, wrote: Please see below ( I want to do step 3 - change a value by 90 degrees) but the answer has to be between 0 and 180 e.g. 45 becomes 90 e.g. 95 becomes 185 (but this is wrong, so SUBTRACT 90 instead) anwer is 5 =MOD(A1+90,180)+(MOD(A1+90,180)=0)*180 Ron, PERFECT I have just realised that your answer is perfect |
#9
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
brainteaser: change a value by 90 (but answer must lie between 0-1
|
#10
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
brainteaser: change a value by 90 (but answer must lie between 0-1
|
#11
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
brainteaser: change a value by 90 (but answer must lie between 0-180 )
On 15 Nov 2005 11:49:37 -0800, wrote:
Ron Rosenfeld wrote: On 15 Nov 2005 11:11:04 -0800, wrote: Please see below ( I want to do step 3 - change a value by 90 degrees) but the answer has to be between 0 and 180 e.g. 45 becomes 90 e.g. 95 becomes 185 (but this is wrong, so SUBTRACT 90 instead) anwer is 5 =MOD(A1+90,180)+(MOD(A1+90,180)=0)*180 Ron, PERFECT I have just realised that your answer is perfect Thank you for the feedback. Glad to help. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) | |||
Use DocProps in a change declaration | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |