Thread: brainteaser: change a value by 90 (but answer must lie between 0-180 )
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
Ron Rosenfeld
 
Posts: n/a
Default 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 With QuoteReply With Quote