I think this would be an if problem

[Lois Ann]

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

 

[CLR]

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

 

[SteveW]

=if(G>270,360-G,IF(G>180,180+G,IF(G>90,180-G,G)))

not the only solution

Steve

 

[Lois Ann]

i tried both solutions and neither one gave me the correct answer. I B3, I
have 301.54, I should get 320.4 in A3. I"m going to try again, but I've tried
them twice already, for each answer that I received.

 

[SteveW]

301 > 270
therefore you said g = 360 - 301.54

How do you get 320.4 ?????????

 

[Lois Ann]

--
Lois Ann


:
On my TI calculator these are the steps that I use:
108.5/301.5=.359867
cos(19.7923)=.940926
301.5/.940923=320.43
108.5=departure
301.5=latitude
320.43=lengh

 

[Pete_UK]

Yes, but how does this relate to your opening post?

Pete

 

[Lois Ann]

Man I"m getting myself confused. On this one I should come up with 340 Degree
and 12 minutes, no wonder I've got every one scratching their heads!
I have another question in the one above this one and I gave the incorrect
answer to this question.
On this one it is
0-90= B3
90-180=180-B3
180-270=180+B3
270-360=360-B3
With B3 being the column and row in excel.
359 degrees 60 minutes -19 degree 48 minutes=340 degrees and 12minutes