conditional equations

[gryffynwolf]

I am needing a code to do 2 different calculations based on a number. I have 1 cell where I have a positive or negative number. If the input is positive (i.e. 2.35) the equation needs to be (((360+the input cell)/10)-180)*60, if the input number is negative (i.e. -3.45) I need it to do the equation ((input cell/10)-180)*60. I need it to display a resultant number based off the result, is this possible?

 

[Michael M]

Maybe this assuming your input cell is A1

=IF(A1>0,((360+A1)/10-180)*60,((A1/10)-180)*60)

 

[Kevin_Li]

=((360*(A1>0)+A1)/10-180)*60

 

[gryffynwolf]

thanks ill try that

 

[gryffynwolf]

it doesn't work but its my fault i see where my question was wrong i need it to use the calculation where it adds 360 if its greater than 0 and use the one without adding the 360 if its less that 360 as in degrees so if its .235 it adds 360 to the calc, if its 359.456 it wouldn't. sorry...

 

[Kevin_Li]

But, .235 is both greater than 0 and less that 360.

 

[gryffynwolf]

not in this case, it would be 0.235 degrees i would need the calculation to add 360, whereas if its 359.554 degrees i wouldn't need to add it. im trying to do utilize 1 cell (say A3) to use one or the other equation depending on what i put into cell A1. its due to a piece of measuring equipment

 

[gryffynwolf]

i do see what your saying though.. could i use a if its between 0 - 10 degrees it would add the 360, or 350 - 360 it wouldnt?

 

[gryffynwolf]

check me but i think this may work
=IF(AND(D25>0,D25<10),((360+D25)/2-C25)*60,IF(AND(D25>350,D25<360),((D25/2)-C25)*60))

 

[Kevin_Li]

What results do you need when it is between 10 and 350?