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

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?

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?

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?

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?

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

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?

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?