Hi everyone -

I am trying to condense this formula. It works, but it seems like there has got to be an easier way to write it.

=IF(AND(C3>=90,C3<=119),(B3*-1),IF(AND(C3>=120,C3<=149),(B3*-2),IF(AND(C3>=150,C3<=179),(B3*-3),IF(AND(C3>=180,C3<=209),(B3*-4),IF(AND(C3>=210,C3<=239),(B3*-5),IF(AND(C3>=240,C3<=269),(B3*-6),IF(AND(C3>=270,C3<=299),(B3*-7),IF(AND(C3>=300,C3<=329),(B3*-8),IF(AND(C3>=330,C3<=359),(B3*-9),IF(C3>=360,(B3*-10),"0.00"))))))))))

As an explanation:

C3 has a value in it anywhere from 0-365.

If the value in C3 is between 0 and 89, I want it to display 0.00.
If the value in C3 is between 90 and 129, I want it to multiply B3 times -1.
For every 30 day period after that, I want it to multiply B3 times -2, then-3, then -4, etc., all the way up to -9.
If C3 is 360 or more, I want it to multiply B3*-10.

I hope this makes sense. If not, I'll try to clarify it.

Thanks a bunch.