IF statement?
Not sure where to start, but here goes. I have been working on creating a
cost estimate. Cell I29 is the total cost. Based on the value in this cell
I would like to multiply it by a certain percentage. I have 16 possiblies;
$1-$100,000 = 20%, $100,001-$200,000 = 19.5%, $200,001 - $300,000 = 19% & so
on.
Excel 2000
|