IF then when If variable changes

[MSTARS]

Okay.. I should probably include the script on this, but (and please dont conisder me igorant!) its "confidential" at this point and not suppose to get out at all so I am going to do my best to describe this. If its not enough information I will make a small template to get the idea out. Thanks in advance for anyone who can figure this out

On the consumer budget part of this spreadsheet, the agent enters in all income and expenses. In a summary box, Total Income, Total Expenses, then total availabe for repayment plan shows up in cell (m72)

Now I would like to have a two merged cells a few up, that , shows "Budget OKay" if it is over x ammount of dollars or "Budget Upside Down" two merged cells to the right of the first if it is under. Simple enough Im sure, but the situation:

Earlier in the spreadsheet, the agent finds out how much debt the client has, and keys in dollar ammounts that assure the client will be out of debt in NO MORE then 46-58 months. But sometimes, this budget is done before that happens and I dont want them to get errors if the payment ammount field is empty.

Can I possible do this:

Have one cell say "Budget OKay" one cell say "Budget Upside down" and one cell say NEED TO ENTER MONTHLY PAYMENT AMMOUNT

[forcybo]

What about something like this in the merged cell:

=If(m72="","NEED TO ENTER MONTHLY PAYMENT AMMOUNT",if(m72>x,"Budget Okay","Budget Upside Down"))

With 'x' being the monetary amount you would like to pre-define. This way you could keep it all in one cell.

[VBA Noob]

MSTARS,

Please read forum rules below and then amend you're title

VBA Noob

[NBVC]

MStars,

Please read our forum rules and come up with a title that is more descriptive of your problem.

Thank you.

[NBVC]

You response has been restored... see the second post above...

[MSTARS]

What about something like this in the merged cell:

=If(m72="","NEED TO ENTER MONTHLY PAYMENT AMMOUNT",if(m72>x,"Budget Okay","Budget Upside Down"))

With 'x' being the monetary amount you would like to pre-define. This way you could keep it all in one cell.

Okay this is a great start. I had to modify it because m72 is the amount that they have available for a payment, but it isnt neccisarily what the agent will type in the cell FOR the payment. They might have more or less depending ont he budget.

So here is what I have done

=IF(H82="","NEED TO ENTER MONTHLY PAYMENT AMOUNT IN H82",IF(M72>300,"Budget Okay","Weak Budget"))

And it works

But it also needs to do this:
I included a demo script