I have a worksheet that totals-up board costs for the company I work for. Whenever the total is greater than $20,000 the cost should be $100, greater than $50,000 is $93, >$100,000 = $92, >$200,000 = $91, and >$500,000 = $87. My spreadsheet will total up everything for me, then my employees hand enter either $100, $93, $92... Is there any way that when the sum is between one of these totals that it can auto-generate $100, $93...??? I tried an IF statement and all I could get is just one of them to form. I don't know how to nest formulas or how to do If then else statements yet. Could anyone help me here? Thanks!!!
Bookmarks