nested fnctions

[Heindrich]

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.

[Marijus]

aSB0aGluayB5b3UgY2FuIGNoYW5nZSBmdWN0aW9uIElGIHdpdGggTE9PS1VQIC4NCldyaXRlIG1v
cmUgaW5mb3JtYXRpb24gYWJvdXQgd2hhdCBhcmUgeW91IHRyeWluZyB0byBkby4NCg0KLS0gDQpN
LkEuDQoiSGVpbmRyaWNoIiA8SGVpbmRyaWNoIEBkaXNjdXNzaW9ucy5taWNyb3NvZnQuY29tPiB3
cm90ZSBpbiBtZXNzYWdlIG5ld3M6MTgxNzgxMDQtRkE3MS00NTE4LUIwRTQtQzZFNUNEOUJFMjRF
QG1pY3Jvc29mdC5jb20uLi4NCj4gDQo+IEkgYW0gYnVzeSBwcm9ncmFtbWluZyBhIHdvcmsgc2hl
ZXQgaW4gZXhlbCAyMDAzLiBJIG5lZWQgdG8gaGF2ZSBtb3JlIHRoYW4gNyANCj4gSWYgZnVuY3Rp
b25zIGluIG9uZSBvZiBteSBmb3JtdWxhcyB0byBwaWNrIHVwIGNvcnJlY3QgYW1vdW50cy4gSG93
IGRvIEkgZG8gDQo+IHRoaXMgYXMgZXhjZWwgb25seSBhbGxvd3MgZm9yIDcu

[Duke Carey]

*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.

[Heindrich]

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.

[Heindrich]

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.

[Duke Carey]

Nope, it doesn't help.

Give us an example of one of your IF formulas and a clear statement of what
your logical 'ifs' are trying to do


"Heindrich" wrote:

> 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.

[MattShoreson]

Setup... In A1 put the StartDate, 1/3/05, in B1 the EndDate 1/2/06.

In C1 put the parameter date of the thing in question, e.g. 1/4/05.

=IF(AND(A3>=A1,A3<=A2),IF(MONTH(A3)>=3,12-MONTH(A3)+3,MONTH(A3)),12)

[MattShoreson]

BTW the last post assumes you want the remaining months in the fiscal year.