Reconfiguring a formula to include "RoundUp"

[TarkTeam4]

(A)
I currently have a formula ... IF(AND(K8>2001,K8<15000),(K8-2000)*0.005)+60
K8 = $2460.00
Producing the final answer to be = $62.30
This formula works out perfectly.

(B)
However, I am now trying to add the "round-up" feature to the nearest thousand of the first portion of the formula ... IF(AND(K8>2001,K8<15000),(K8-2000)
(where again) K8 = $2460.00
Producing the answer to be = $460
Rounding up the answer to the nearest thousand would come out to = $1000

Then including the latter portion of the formula to the $1000 ... *0.005)+60
Bringing the final answer out to be = $65.00

How can I rewrite formula (A) that would include (B) "RoundUp" to the nearest thousand and get the results I am looking for?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(AND(K8>2001,K8<15000),CEILING(K8-2000,1000)*0.005)+60

 

[TarkTeam4]

Hi & welcome to MrExcel.
How about

=IF(AND(K8>2001,K8<15000),CEILING(K8-2000,1000)*0.005)+60

AWESOME!!!! That worked perfectly. You have saved me hours of trying to reconfigure it myself. Thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback.