i'm not sure what is in J49 so I can't tell exactly what you are trying to do
with this formula, but you are missing the final argument of the function
which is to tell Excel what to do if the first argument is false, i.e.
J4650000. As written this will simply result in FALSE when you get over
50000.

"Nancy E" wrote:

I'm working on a cash flow chart and I can't figuare out how to get the
formula to work. I have been try to use IF functions. Here is the problem.
Cash balance must be kept at $50,000 if lower loan needs to be increased, if
cash balance is over $50,000 then amount over goes back to loan. I also must
deduct interest before additional money is taken or given back. So far I have
come up with the following formula which worked until we got over $50,000 and
I need to put money back.
=IF(J46<=50000,((50000+J49))-J46) Thanks for any help. Nancy E