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!