Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Increasing payment in future value formula? | Excel Worksheet Functions | |||
copy formula down 1000,s of lines | Excel Worksheet Functions | |||
1000+$K$5/1000 -what does $ indicate in formula | Excel Worksheet Functions | |||
Specifying the person who has achieved the highest result | Excel Worksheet Functions | |||
Rounding to the next highest 1000 after a resulting formula | Excel Worksheet Functions |