Thanks everyone. I'm working with the different solutions offered here.

"Markus L" wrote in message
...
"Brenda Rueter" wrote in message
...
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

Brenda, try this one:
=IF(C8xxx,C6-180,IF(C8xx,C6-150,IF(C8x,C6-120,C6-90)))
Not elegant at all, a simple translation of your requirements.