Problemas con funcion

Topic

New Reply

Tengo un problema con una funcion “SI” anidada. Necesito que dando un valor a una celda me busque, dependiendo del valor en 12 rangos (mensuales) distintos, y mi problema es que no me deja anidar mas de 7 “SI”.
Hay alguna manera de solventar esto??
Si alguien lo sabe hacer con codigo, y es posible que me lo postee aqui o me lo envie.

Muchas Gracias.

Reply | Quote

Replies

Perdone mi espa

Reply | Quote

Yes, I post you my file and a little explain inside it.
I think you can understand it..
If no, just post me a message …

Thanks.

Reply | Quote

Hello,

I inserted 2 columns (A & and entered numbers from 1 to 12 in A, and the composed a VLOOKUP, using the fact that columns of values are spaced 4 columns apart.

DataTable =Hoja1!$A$3:$AW$14
G3 = VLOOKUP(D38,DataTable,D38*4,FALSE)

Does that help ?

Andrew C

Reply | Quote

I think that it would work….
I will try to complete all the sheet and i will tell you…
Thanks a lot..

I was trying to do it more difficult that it was… i think… Thanks again for all..!!!!

I

Reply | Quote

It is possible to overcome the limit of 7 nested IFs by using named formulas. The last CONDITION_FALSE in the first formula is the name of the second formula. For example for your problem define FirstIF as

=IF(Sheet1!A1=1,”Jan”,IF(Sheet1!A1=2,”Feb”,IF(Sheet1!A1=3,”Mar”,IF(Sheet1!A1=4,”Apr”,IF(Sheet1!A1=5,”May”,IF(Sheet1!A1=6,”Jun”,SecondIF)))))).

Then define SecondIF as

=IF(Sheet1!A1=7,”Jul”,IF(Sheet1!A1=8,”Aug”,”ERROR”))

I have only taken the example up to August, but obviously it can be extended. This way there does not seem to be a limit on the number of nested IFs.

Beware that as written the references are relative and odd things happen if you have the selected cell in a different location from where it was when you wrote the formula. You may think it better to use absolute references.

To use these nested IFs go to the cell where you want the result then use Insert/Name/Paste and paste FirstIF in the cell.

Reply | Quote