"if then else" function in Ms Excel 2007.?

Yep, you've overdone on nesting, to solve this it is easiest to split your commands up into several cells other methods include LOOKUP, but that will take you way too long.

Last I heard, Excel had like 255 nesting levels, but that was before crappy 2007... I doubt you have that many levels. I've OFTEN gone over 7 levels without a problem.

I would use other cells as "Subtotal" cells, have the inner-most nesting in other cells which are out of view (like even on another sheet in the same file), and that should double your capabilities.

If funky things are happening, I find it useful to copy elsewhere and split it up, programming style, like:

=IF(A2<5,

_tab_"Low",

_tab_IF(A2<10,

_tab__tab_"Medium",

_tab__tab_IF(A2<15,

_tab__tab__tab_"High",

_tab__tab__tab_"Astronomical"

_tab__tab_)

_tab_)

)

...and in this way, clarify the flow to myself, make sure the logic works out correctly. (Sorry, it threw away my spacing, I had to use "_tab_" to illustrate)

excel has a limitation of a 7 nesting levels. If your nesting levels exceed this maximum, you get the error you described. You'll have to re-think of a different way of doing whatever you're trying to do.

The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. I think from your description what you need is =COUNTIF(A6:A11,"rent") repeat for similar formula for other 5 types of expenses HTH

You should consider doing this in VB code, using an IF or CASE loop.

y