| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have some problem with database | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
