Calculating new value based on range of set criteria

[Flyingcat]

Would highly appreciate any help on this. I have tried for a number of hours but can't seem to find a solution.

I'm trying to calculate a new value if a calculated value in a cell is less than 0 or greater than 360.

The conditions are:

If the cell's value is equal to or between 0 and 360 then no calculation is required.

If the cell's value is less than zero then 360 has to be added to the cell's value.

If the the cell's value is greater than 360 then 360 has to subtracted from the cell's value.

For example:

1) If the calculated cell value in A1 is 100 then B1 would show 100

2) If the calculated cell value in A1 was -10 (minus 10) then B1 would show 350 i.e. (-10+350)

3) If the calculated cell value in A1 was 370 then B1 would show 10 i.e. (370-360)

Any idea what formula I should use in cell B1 to accomplish this?

Thanks in advance.

 

[T. Valko]

Would highly appreciate any help on this. I have tried for a number of hours but can't seem to find a solution.

I'm trying to calculate a new value if a calculated value in a cell is less than 0 or greater than 360.

The conditions are:

If the cell's value is equal to or between 0 and 360 then no calculation is required.

If the cell's value is less than zero then 360 has to be added to the cell's value.

If the the cell's value is greater than 360 then 360 has to subtracted from the cell's value.

For example:

1) If the calculated cell value in A1 is 100 then B1 would show 100

2) If the calculated cell value in A1 was -10 (minus 10) then B1 would show 350 i.e. (-10+350)

3) If the calculated cell value in A1 was 370 then B1 would show 10 i.e. (370-360)

Any idea what formula I should use in cell B1 to accomplish this?

Thanks in advance.

I think this should do it...

=IF(A1<0,A1+360,IF(A1>360,A1-360,A1))

 

[Flyingcat]

Hi Biff,

Many thanks for your quick response, elegant formula and also for taking the time to reply, it works perfectly. Much appreciated.

Frank.

 

[T. Valko]

Hi Biff,

Many thanks for your quick response, elegant formula and also for taking the time to reply, it works perfectly. Much appreciated.

Frank.

You're welcome. Thanks for the feedback!