How to create advanced IF statements on Excel?

Question

I am having a little trouble creating a spreadsheet in excel. For a surveying class, I need to create a spreadsheet to input bearings, latitudes, and departures.

Departures are easy for if statements because if the angle is less than 180 degrees, the departure is in an easterly direction. If the angle is greater than 180, then it is in a westerly direction.

My problems come with calculating latitudes (north or south). For north, the logic statement should be if the angle is less than 90 degrees or greater than 270 degrees, and vice versa for the south calculation.

How can I use a logic statement for this calculation?

Answer 1

you need to use a nested if.

so you got your 1st if working, and it would look something like this



=IF(A1<180,"east","west")



but for N,S,E,W you would use a nested if...in other words when calculation is FALSE, then you just start up another if() statement.



=IF(A1<90,"south", IF(A1<180,"east", IF(A1<270,"west","north")))



so if all calculations are false, then north shows up.



edit-

you can add more if() statements to that. you know someone is going to type 1000 or something stupid just to "see what happens". you can give a "that doesnt exist" result. or else use data validation.

Answer 2

Advanced If Statements In Excel

Answer 3

right here ya bypass... =IF(A6="C",IF(B6>0,IF (B6<=a million,"sparkling","examine"), "examine"),IF(A6="P",IF(B6<0, IF(B6>=-a million,"sparkling","examine"), "examine"))) certainty is which you would be a lot greater advantageous off with an if fact that contained lookups fairly then the addtn'l if statements. additionally, in case you needed to return a sparkling area, fairly than the text textile "sparkling" merely eliminate the 5 letter and bypass away the expenditures.