I think this would be an if problem
 

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

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

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

I think this would be an if problem
 

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


"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

I think this would be an if problem
 

301 270
therefore you said g = 360 - 301.54

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


On Wed, 02 Aug 2006 21:18:46 +0100, Lois Ann
wrote:

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.



--
Steve (3)

I think this would be an if problem
 

--
Lois Ann


"SteveW" wrote:
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

301 270
therefore you said g = 360 - 301.54

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


On Wed, 02 Aug 2006 21:18:46 +0100, Lois Ann
wrote:

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.



--
Steve (3)

I think this would be an if problem
 

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

Pete

Lois Ann wrote:
--
Lois Ann


"SteveW" wrote:
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

301 270
therefore you said g = 360 - 301.54

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


On Wed, 02 Aug 2006 21:18:46 +0100, Lois Ann
wrote:

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.



--
Steve (3)

I think this would be an if problem
 

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
--
Lois Ann


"SteveW" wrote:

301 270
therefore you said g = 360 - 301.54

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


On Wed, 02 Aug 2006 21:18:46 +0100, Lois Ann
wrote:

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.



--
Steve (3)