View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
confused confused is offline
external usenet poster
 
Posts: 193
Default Multiples of 1000 in cells?

if i say, "if a #<0, then put the # i'm trying to determine up to the next
highest multiple of 1,000" or "If #0, then put the # i'm trying to down to
the last multiple of 1,000."
-For example, if the number was -410,700 and i was trying to get it to equal
50,000, so i would add 460,700. however, 460,700 can only be increments of
1,000, so since -410,700 is less than zero, i would make 460,000 go up to the
next highest multiple of 1,000 which would be 461,000. this keeps my result
at greather than or equal to 50,000.
HOW WOULD I PUT THAT INTO AN EQUATION?!?

"Confused" wrote:

How can I write and embedded IF statement that only occurs in multiples of
1000?