I think this would be an if problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
--
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
 
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
 
Back
Top