LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
mz mz is offline
external usenet poster
 
Posts: 40
Default Formula for increasing a result to the next highest 1000

A certain tax formula requires increasing the result of a subtraction of two
numbers to the next highest 1000
For example, when subtracting 2250 from 5000, the result of 2750 must be
increased by 250, which is the next highest 1000; this would also be the case
if 2250 is subtracted from 4300, which results in 2050 - you would increase
it to 2100.

If cell A1 is the higher number, Cell A2 is the lower number, and the result
is in Cell A3, what would be the formula in Cell A3 for increasing the result
to the next highest 1000?

The formula needs to be part of an "If" function, since if the subtraction
yields zero, then zero must be in Cell A3.

Thank you
--
MZ
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Increasing payment in future value formula? AXPJESTER Excel Worksheet Functions 5 May 20th 23 07:43 PM
copy formula down 1000,s of lines gfj Excel Worksheet Functions 2 November 5th 08 08:40 PM
1000+$K$5/1000 -what does $ indicate in formula Coolbhims Excel Worksheet Functions 1 March 16th 06 11:51 AM
Specifying the person who has achieved the highest result Mary Ann Excel Worksheet Functions 8 December 5th 05 07:08 AM
Rounding to the next highest 1000 after a resulting formula Katiemcgi Excel Worksheet Functions 6 November 9th 04 09:10 PM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"