Hi Bamse,

Still not fully understanding what the argument you require should look like, I will attempt to provide you with the following hoping it matches your needs but if you could provide a detailed written explanation of what you want to happen without using any excel functions. or if possible even upload a sample spreadsheet.

=if(and(E11="N",E12="N"),if(F11>F12,"S","N"),if(and(F12="S",F11>G12),"N","S"))

I have tried to take it a little apart here, and chanced it a little. Now it returns whit #NAME?

It is a part of a great circle sheet I am trying I creat or school. Where we have a start potision that is 55 N and ends in 45 N. Just to take some numbers.

=IF(F11=”N”;IF(F12=”N”;IF(E11>E12;”S”;”N”);”S”);IF(F12=”S”;IF(E11>E12;”N”;”S”);”N”))

=IF(E11=”N”;
Then
IF(E12=”N”;
Then
IF(F11>F12;”S”;”N”)
Else
;”S”)
Else
IF(E12=”S”;
Then
IF(F11>F12;”N”;”S”)
Else
;”N”))

Hi Bamse,

When using functions if any characters are not purely numeric they need to be enclosed by inverted comma's "".

Also reading your function you need to use comma's , not semi colons ; to seperate different facets of a function. also don't close the bracket of an if function without completing all 3 facets for (statement,true,false)

without knowing what you wish to do I cannot assist any further as to put it politely your function above makes no sense whatsoever

Regards
Mark