Thread: I think this would be an if problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
  
Posts: 1,998
Default I think this would be an if problem
Maybe this.........

=IF(g<=90,g,IF(g<=180,180-g,IF(g<=270,180+g,IF(g<=360,360-g,""))))

Vaya con Dios,
Chuck, CABGx3




"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
--
Lois Ann
Reply With QuoteReply With Quote