Multiples of 1000 in cells?
 

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

Multiples of 1000 in cells?
 

Your question is not explicit enough to understand what you want. Can you
post a sample of your data and an explanation of what you want to achieve.

Regards,

OssieMac

"Confused" wrote:

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

Multiples of 1000 in cells?
 

I am trying to create a cash budget. These are the numbers:
(410,700) 99,735 109040
??? ??? ???
50,300 50735 50040

The top number is a cash surplus (shortage), the middle number is borrowing
for a loan (or repayment) and the bottom number is the ending cash balance.
The ending cash balance must always be at least 50,000 and I have to borrow
in increents of 1,000. The three middle numbers should be 461,000, (38000),
and (59,000) respectively. I cannot figure out how to create a formula to
make this work for any combination of numbers. How do I create a formula to
make it so that I am either borrowing or repaying money based on the top
number that maintains my minimum ending cash balance of 50,000, but is only
in increments of 1,000? I was trying to do an imbedded "If" statement, but I
can't figure it out.

"OssieMac" wrote:

Your question is not explicit enough to understand what you want. Can you
post a sample of your data and an explanation of what you want to achieve.

Regards,

OssieMac

"Confused" wrote:

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

Multiples of 1000 in cells?
 

I am trying to create a cash budget. These are the numbers:
(410,700) 99,735 109040
??? ??? ???
50,300 50735 50040

The top number is a cash surplus (shortage), the middle number is borrowing
for a loan (or repayment) and the bottom number is the ending cash balance.
The ending cash balance must always be at least 50,000 and I have to borrow
in increents of 1,000. The three middle numbers should be 461,000, (38000),
and (59,000) respectively. I cannot figure out how to create a formula to
make this work for any combination of numbers. How do I create a formula to
make it so that I am either borrowing or repaying money based on the top
number that maintains my minimum ending cash balance of 50,000, but is only
in increments of 1,000? I was trying to do an imbedded "If" statement, but I
can't figure it out.

"OssieMac" wrote:

Your question is not explicit enough to understand what you want. Can you
post a sample of your data and an explanation of what you want to achieve.

Regards,

OssieMac

"Confused" wrote:

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

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?

Multiples of 1000 in cells?
 

=IF(A1=0,FLOOR(A1-50000,1000),CEILING(-A1+50000,1000))*SIGN(A1)

With first value in A1, above formula in A2 and copied right, and =A1-A2
entered in A3 and copied right, you get the following resurlts:

-410700 99735 109040
-461000 49000 59000
50300 50735 50040



"Confused" wrote:

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?

Multiples of 1000 in cells?
 

Try

=CEILING(ABS(A1-A3),1000)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Confused" wrote in message
...
I am trying to create a cash budget. These are the numbers:
(410,700) 99,735 109040
??? ??? ???
50,300 50735 50040

The top number is a cash surplus (shortage), the middle number is
borrowing
for a loan (or repayment) and the bottom number is the ending cash
balance.
The ending cash balance must always be at least 50,000 and I have to
borrow
in increents of 1,000. The three middle numbers should be 461,000,
(38000),
and (59,000) respectively. I cannot figure out how to create a formula to
make this work for any combination of numbers. How do I create a formula
to
make it so that I am either borrowing or repaying money based on the top
number that maintains my minimum ending cash balance of 50,000, but is
only
in increments of 1,000? I was trying to do an imbedded "If" statement,
but I
can't figure it out.

"OssieMac" wrote:

Your question is not explicit enough to understand what you want. Can you
post a sample of your data and an explanation of what you want to
achieve.

Regards,

OssieMac

"Confused" wrote:

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

Multiples of 1000 in cells?
 

THANK YOU SO MUCH!!!! That worked! You have been a huge help! Thanks again!

"BoniM" wrote:

=IF(A1=0,FLOOR(A1-50000,1000),CEILING(-A1+50000,1000))*SIGN(A1)

With first value in A1, above formula in A2 and copied right, and =A1-A2
entered in A3 and copied right, you get the following resurlts:

-410700 99735 109040
-461000 49000 59000
50300 50735 50040



"Confused" wrote:

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?