Thread
:
brainteaser: change a value by 90 (but answer must lie between 0-180 )
View Single Post
#
8
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
[email protected]
Posts: n/a
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
Reply With Quote