Joined
·
5 Posts
Can someone help me with what seems to be a little above my head. I am trying to compute an IF statement for four variables. It is a cost analysis that states:
If cell A1 is:
1. Less than $25, fee is 12% of that value
2. Between $25.01 and $100 the fee is 12% of the first $25 and 8% or remaining value.
3. Between $100.01 and $1,000, the fee is 12% of first $25, 8% of subsequent $74.99 and 4% of remaining value
4. $1,000.01 and up (all above criteria and 2% of anything over the $1,000.01.
I tried and tried, but could not make it work...
Any help is appreciated.
Thank you,
CAC
If cell A1 is:
1. Less than $25, fee is 12% of that value
2. Between $25.01 and $100 the fee is 12% of the first $25 and 8% or remaining value.
3. Between $100.01 and $1,000, the fee is 12% of first $25, 8% of subsequent $74.99 and 4% of remaining value
4. $1,000.01 and up (all above criteria and 2% of anything over the $1,000.01.
I tried and tried, but could not make it work...
Any help is appreciated.
Thank you,
CAC
