Help! < in a formula even more complicated!

[Guest]

I want to make a formula for a cell that will take the amount for L2 and
apply this information:
$0.01 – $25.00 5.25% of the closing value
$25.01 – $1,000.00 5.25% of the initial $25.00 ($1.31), plus 2.75% of the
remaining closing value balance ($25.01 to $1,000.00)
Over $1,000.01 5.25% of the initial $25.00 ($1.31), plus 2.75% of the
initial $25.00 - $1,000.00 ($26.81), plus 1.50% of the remaining closing
value balance ($1,000.01 - closing value)

 

[Rick B]

Cell? L2? Are you using Excel?

This is an Access newsgroup, not an Excel newsgroup.

 

[Garret]

Well if this Access, I can tell you the VB code for it, I don't know
about the SQL.

If ClosingValue >= .01 and ClosingValue <= 25.00 then
ClosingValue = ClosingValue * 1.0525
Elseif ClosingValue >= 25.01 and ClosingValue <= 1000.00 then
ClosingValue = (25.00 * 1.0525) + ((ClosingValue - 25.00) * 1.0275)
Else
ClosingValue = (25.00 * .0525) + ((1000.00) * .0275) + (ClosingValue
* 1.015)
End if

This is assuming the Closing Value gains the % of interest, and it
isn't a totally new value. If the latter is the case, just remove the
1 from the decimal values that ClosingValue gets multiplied by.