Nested logic? Array formula?

Originally Posted by Brisbane Rob

A budget line can be positive or negative (revenues or expenses). Performance against the budget line can be 'better than budget', or 'worse than budget'.

What formula will tell you whether performance is better or worse than budget, and tell you if the position has improved comparing it with performance for the previous period?

The permutations seem endless to me - you run out of nesting 'if' statements long before you run out of possible combinations.

Any ideas?

Hi,

irrespective of negative or positive figures, if figure = budget = 'expected', if expenses are less than budget it's 'better', if incomes are more than budget it's 'better', otherwise it's 'worse'

something like

=If(figure=budget,"Expected".If(or(and(figure<budget,type=expense),and(figure>budget,type=income)),"better","Worse"))

hth
---

Originally Posted by Brisbane Rob

I like your thinking - simple, but it works. Thanks

I like it simple so that I can understand it, thanks for your response.

---