Hello all! (first post)

Have a question about writing a formula to capture a business scenario that requires calculations to be different depending on how many units are sold. I thought I had the model down, but when I tried to input all the numbers it did not work! note - this is not for a work situation this is just something I came across in a course. Thanks in advance!

[TABLE="border: 1, cellpadding: 1, width: 500"]

units (conditions)

[/td][td]if condition met, then display or do following

[/td][/tr][tr][td]Less Than 80,000

[/td][td]N/A

[/td][/tr][tr][td]80000

[/td][td]2,800,000

[/td][/tr][tr][td]80,001-90,000

[/td][td]multiply # of units by $35

[/td][/tr][tr][td]90,001-100,000

[/td][td]multiply # of units by $45

[/td][/tr][tr][td]Above 100,001

[/td][td]multiply # of units by $55

[/td][/tr]

[/TABLE]

I will give a few values to use.just need some help generating the formula so this is more or less automated

99642

243989

114597

125887

88000

92000

Please let me know if more information is needed and can go from there. Thanks!