IF Formula Clarification
Here's how my spreadsheet looks: I'm trying to get a result in cell A1 that shows =if(b4 is between 0 and 10,000, c4*b4, if(b4 is between 10,001 and 20,000, d4*b4, if(b4 is between 20,001 and 30,000, e4*b4).
b4
10000
c4
2%
d4
4%
e4
6%
I hope this amply clarifies my need. Thanks again.