I am developing an asset register that complies with new IFRS requirements.

So i have a financial year that begins in march 2004 and ends Feb 2005. So
the formula I am writing picks up additions in this period and disposals
within the date range and then has to return the amount of months remaining
in that year, and if the asset was not purchased in the given date range it
has to return the value of 12 (months for the year)

Hope this helps

"Duke Carey" wrote:

*Usually* you will find there are easier ways to do things than lots of
nested IFs. Give us an idea of what you are trying to accomplish and we can
help you out.



"Heindrich" wrote:


I am busy programming a work sheet in exel 2003. I need to have more than 7
If functions in one of my formulas to pick up correct amounts. How do I do
this as excel only allows for 7.