nested fnctions

H

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

Marijus

i think you can change fuction IF with LOOKUP .
Write more information about what are you trying to do.

--
M.A.
 
D

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

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
 
D

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
 
M

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)
 
M

MattShoreson

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