(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?
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?