Need help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

IF(B4>A4,"overspent",IF(AND(B4<A4,C4,"ok",),"problem"))


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
 
Try this:

=IF(B4>A4,"overspent",if(and(B4<A4,C4),"ok","problem"))

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
 
momotaro said:
Thanks Dave. This is what I did, however it seems it did not work. Here is
the formula. Please advise. thanks

IF(B4>A4,"overspent",IF(AND(B4<A4,C4,"ok",),"problem"))


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
Click to expand...
Your formula is now:
IF(B4>A4,"overspent",IF(AND(B4<A4,C4,"ok",),"problem"))
Change it to:
IF(G4>A4,"overspent",IF(AND(B4<A4,C4>3),"ok"),"problem"))


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.
 
ed said:
Your formula is now:
IF(B4>A4,"overspent",IF(AND(B4<A4,C4,"ok",),"problem"))
Change it to:
IF(G4>A4,"overspent",IF(AND(B4<A4,C4>3),"ok"),"problem"))
Click to expand...
Whoops delete the ) after "ok" so formula should be:

=IF(G4>A4,"overspent",IF(AND(B4<A4,C4>3),"ok","problem"))

sorry, ed
 
Back
Top