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

[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




"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

[SteveW]

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

not the only solution

Steve



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

<[email protected]> wrote:

> How would I write this? G=3D degrees.
> If 0-90 degrees =3D G
> If 90-180 degrees =3D180-G
> If 180-270 degrees =3D 180+G
> IF 270-360 degrees =3D 360-G

[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.
--
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

[SteveW]

301 > 270
therefore you said g =3D 360 - 301.54

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


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

<[email protected]> wrote:

> i tried both solutions and neither one gave me the correct answer. I B=
3, =

> I
> have 301.54, I should get 320.4 in A3. I"m going to try again, but I'v=
e =

> tried
> them twice already, for each answer that I received.



-- =

Steve (3)

[Lois Ann]

--
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
> <[email protected]> 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)
>

[Pete_UK]

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
> > <[email protected]> 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)
> >

[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
--
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
> <[email protected]> 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)
>