LinkBack URL
About LinkBacks
I seem to be stumped on what should be an easy formula. I need an if function that will come back with the following:
G7>0 = "Over Budget"
G7<0 = "Under Budget"
G7=0 = blank
I seem to be stumped on what should be an easy formula. I need an if function that will come back with the following:
G7>0 = "Over Budget"
G7<0 = "Under Budget"
G7=0 = blank
May be:
=IF(G7=0,"",IF(G7>0,"Over Budget","Under Budget"))
Quang PT
=IF(G7=0,"",IF(G7>0,"Over","Under")&" Budget"))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Or similarly,
=CHOOSE(SIGN(G7)+2, "Under Budget","","Over Budget")
Entia non sunt multiplicanda sine necessitate
Opps!
Can somebody else offer other solution? i.e, with array formula?
''''^''''1
All three of these are still returning "Over Budget" for $0 in G7. I can't figure out why. It should be a simple fix, but it just doesn't seem to want to work.
Test to see if the 0 is in fact a value and not just test looking like a value. Test with =isnumber(cell-ref)...FALSE indicates text. Where are the values coming from?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The value in G7 is the result of a formula where the amount spent in a given week is subtracted from the budgeted total for that week. It's in currency and comes from values that fall in exact cents. It works perfectly in an if formula with only two options written as =IF(G7>0,"Under Budget","Over Budget"). The only problem is that when I have a perfect budget to spent match resulting in G7 being $0.00 it tells me "Over Budget". It's not a real long-run problem, but I'm a bit of a perfectionist and it's annoying.
Maybe the answer is not exactly zero.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks