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
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
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
=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
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
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
"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)
>
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)
> >
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)
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks