Thread: I think this would be an if problem
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
SteveW SteveW is offline
external usenet poster
  
Posts: 427
Default I think this would be an if problem
=if(G270,360-G,IF(G180,180+G,IF(G90,180-G,G)))

not the only solution :)

Steve



On Wed, 02 Aug 2006 17:20:02 +0100, Lois Ann
wrote:

How would I write this? G= degrees.
If 0-90 degrees = G
If 90-180 degrees =180-G
If 180-270 degrees = 180+G
IF 270-360 degrees = 360-G
Reply With QuoteReply With Quote