=IF(C8<A1,C6-90,IF(C8<A2,C6-120,IF(C8<A3,C6-150,C6-180)))

a1 = x
a2 = xx
a3 = xxx

"Brenda Rueter" wrote:

User wants to combine within one formula:
If C8 < x,then C6-90
If C8 x but under xx, C6-120
If C8 xx but < xxx, C6-150
If C8 xxx, C6-180

Is there a function that will do the in-between parts for me?