Thanks Dave. This is what I did, however it seems it did not work. Here is
the formula. Please advise. thanks

IF(B4A4,"overspent",IF(AND(B4<A4,C4,"ok",),"probl em"))


A B C
Budget Balance Month left
2,000.00 10.00 2
10,000.00 9,800.00 3.8
3,000.00 3,100.00 2



"Dave F" wrote:

IF(BalanceBudget,"overspent",if(and(balance<budge t,months
left=3.8),"OK",),"problem"))

Dave
--
Brevity is the soul of wit.


"momotaro" wrote:

I need to set up formula and I need help! For example,

1. If balance $$$ is more than budget $$$, it will show €œoverspent€� as a
comment
2. If balance $$$ is less than budget and there are 3.8 months to spent the
budget, it will show €œOK€�
3. If balance $$$ is too close to the budget, it will show €œProblem€�,
because balance is too small and there are 2 more months left.

Budget Balance Month left Comment

2,000.00 10.00 2.0 Problem
10,000.00 9,800.00 3.8 OK
3,000.00 3,100.00 2 overspent

Please help! Thank you.

Try this:

=IF(B4A4,"overspent",if(and(B4<A4,C4),"ok","probl em"))

The syntax you have is slightly garbled. Here are the issues with your
formula: First, the AND function needs to be enclosed in parentheses before
you put the "ok" argument. Second, you put an extraneous comma after the
"ok". Third, you put an extraneous parenthese after the extraneous comma.

But I'm not sure what the C4 argument in your formula does. If you look at
that nested IF clause, you're saying "IF (B4 is greater than A4) and C4, then
OK, else problem." There's no decision being made about the content of C4.
What are you trying to do with that argument?

Dave

Dave
--
Brevity is the soul of wit.


"momotaro" wrote:

Thanks Dave. This is what I did, however it seems it did not work. Here is
the formula. Please advise. thanks

IF(B4A4,"overspent",IF(AND(B4<A4,C4,"ok",),"probl em"))


A B C
Budget Balance Month left
2,000.00 10.00 2
10,000.00 9,800.00 3.8
3,000.00 3,100.00 2



"Dave F" wrote:

IF(BalanceBudget,"overspent",if(and(balance<budge t,months
left=3.8),"OK",),"problem"))

Dave
--
Brevity is the soul of wit.


"momotaro" wrote:

I need to set up formula and I need help! For example,

1. If balance $$$ is more than budget $$$, it will show €œoverspent€� as a
comment
2. If balance $$$ is less than budget and there are 3.8 months to spent the
budget, it will show €œOK€�
3. If balance $$$ is too close to the budget, it will show €œProblem€�,
because balance is too small and there are 2 more months left.

Budget Balance Month left Comment

2,000.00 10.00 2.0 Problem
10,000.00 9,800.00 3.8 OK
3,000.00 3,100.00 2 overspent

Please help! Thank you.

momotaro wrote:
Thanks Dave. This is what I did, however it seems it did not work. Here is
the formula. Please advise. thanks

IF(B4A4,"overspent",IF(AND(B4<A4,C4,"ok",),"probl em"))


A B C
Budget Balance Month left
2,000.00 10.00 2
10,000.00 9,800.00 3.8
3,000.00 3,100.00 2



"Dave F" wrote:

IF(BalanceBudget,"overspent",if(and(balance<budge t,months
left=3.8),"OK",),"problem"))

Dave
--
Brevity is the soul of wit.


"momotaro" wrote:

I need to set up formula and I need help! For example,

1. If balance $$$ is more than budget $$$, it will show "overspent" as a
comment
2. If balance $$$ is less than budget and there are 3.8 months to spent the
budget, it will show "OK"
3. If balance $$$ is too close to the budget, it will show "Problem",
because balance is too small and there are 2 more months left.

Budget Balance Month left Comment

2,000.00 10.00 2.0 Problem
10,000.00 9,800.00 3.8 OK
3,000.00 3,100.00 2 overspent

Please help! Thank you.

Your formula is now:
IF(B4A4,"overspent",IF(AND(B4<A4,C4,"ok",),"probl em"))
Change it to:
IF(G4A4,"overspent",IF(AND(B4<A4,C43),"ok"),"pro blem"))


ed

This is what I am trying to do.
I need to keep track of people spending. If they use more than what it is
budgeted then it would be "Overspent", or "OK" to use or "problem" if its
money will be running out soon. For example, if balance $$ amount is greater
than budget $$, it is overspent, and there is two more months left until the
budget is expired.



"Dave F" wrote:

Try this:

=IF(B4A4,"overspent",if(and(B4<A4,C4),"ok","probl em"))

The syntax you have is slightly garbled. Here are the issues with your
formula: First, the AND function needs to be enclosed in parentheses before
you put the "ok" argument. Second, you put an extraneous comma after the
"ok". Third, you put an extraneous parenthese after the extraneous comma.

But I'm not sure what the C4 argument in your formula does. If you look at
that nested IF clause, you're saying "IF (B4 is greater than A4) and C4, then
OK, else problem." There's no decision being made about the content of C4.
What are you trying to do with that argument?

Dave

Dave
--
Brevity is the soul of wit.


"momotaro" wrote:

Thanks Dave. This is what I did, however it seems it did not work. Here is
the formula. Please advise. thanks

IF(B4A4,"overspent",IF(AND(B4<A4,C4,"ok",),"probl em"))


A B C
Budget Balance Month left
2,000.00 10.00 2
10,000.00 9,800.00 3.8
3,000.00 3,100.00 2



"Dave F" wrote:

IF(BalanceBudget,"overspent",if(and(balance<budge t,months
left=3.8),"OK",),"problem"))

Dave
--
Brevity is the soul of wit.


"momotaro" wrote:

I need to set up formula and I need help! For example,

1. If balance $$$ is more than budget $$$, it will show €œoverspent€� as a
comment
2. If balance $$$ is less than budget and there are 3.8 months to spent the
budget, it will show €œOK€�
3. If balance $$$ is too close to the budget, it will show €œProblem€�,
because balance is too small and there are 2 more months left.

Budget Balance Month left Comment

2,000.00 10.00 2.0 Problem
10,000.00 9,800.00 3.8 OK
3,000.00 3,100.00 2 overspent

Please help! Thank you.

ed wrote:
Your formula is now:
IF(B4A4,"overspent",IF(AND(B4<A4,C4,"ok",),"probl em"))
Change it to:
IF(G4A4,"overspent",IF(AND(B4<A4,C43),"ok"),"pro blem"))

Whoops delete the ) after "ok" so formula should be:

=IF(G4A4,"overspent",IF(AND(B4<A4,C43),"ok","pro blem"))

sorry, ed