Cell Formulation
I just reread my post and I have a feeling I made a mistake because
3200-C5 in your example would produce 200, when really you want 3000-1600 to
give you 1400... so to fix that
Change the line that says 3200-C5 to C5-1600. Then it should work. Sorry
"akphidelt" wrote:
Try this for the first level
=If((C5-1600)0,1600*.0225,(1600-C5)*.0225)
For the second level
=If((C5-3200)0,1600*.0275,If(C51600,(3200-C5)*.0275,0))
This is untested, but maybe it will work, haha
"tracyjollf" wrote:
Can a cell be formulated to reflect a value based on the following situation?
Cell C5 is $34000.00; the first $1600.00 of that amount + the value of C7
needs to be multiplied * 2.25%. That value will be in cell C10. ALSO,
Cell C5 is $34000.00; the second $1600.00 up to $3200.00 needs to be
multiplied * 2.75%. That value will be in cell C11.
EXAMPLE: $34000.00
1st level 1600.00 * 2.25% = $36.00
2nd level 1600.00 * 2.75% = $44.00
ANOTHER EXAMPLE: $3000.00
1st level 1600.00 * 2.25% = $36.00
2nd level 1400.00 * 2.75% = $38.50
I am using Excel 2003 version.
|