Re: Nested If
That's not more than seven Ifs. Do you want the formula in A10?
Re: Nested If
Can you attach a small example file so we can see what values & how many potential IFs ?
Usually, this sort of thing can be solved without the need for VBA - there are alternatives to IF statements that will give you the result you want.
Re: Nested If
=MAX((A1:A10<>0)*(ROW(A1:A10)))
which is an array formula, so commit with Ctrl-Shift-Enter.
Wigi
Re: Nested If
D44 contains Text - Totaal. Try deleting the text.
Re: Nested If
Hi Wilna
I have changed B48.
Take a look and see if you can use this.
Alring
Re: Nested If
Try this
=OFFSET(D7,COUNTA(D7:D43)-1,0)
Re: Nested If
With this formula, you can have the desired result:
=INDIRECT(ADDRESS(MAX(((D8:D43<>0)*(ROW(D8:D43))*(ISNUMBER(D8:D43)))),4))Put it in cell B48. Conclude not with enter, but with Ctrl-Shft-Enter.
The solution by Alring is wrong, ik looks for a maximum, not the last cell in a range.
The solution by Will R does not take into count empty cells.
However, it's up to you to choose which one you like most, Wilna.
Wigi
Re: Nested If
Hi Wigi
As fare as I can see then is it then highest number that Wilna want to have. And If i understand you code too then is it also the highest number you get.
But let us see which one Wilna want to use.
Alring
Re: Nested If
Alring,
your formula gives the maximum, WillR's and mine give the value (not necessarily the maximum) of the range D8:D43. But when the values are non-decreasing, our outcomes will be identical 
Wigi
Re: Nested If
Hi Wigi
That's right.
Re: Nested If
Hi,
Try,
=LOOKUP(9.99999999E+307,D7:D43)
HTH
Don’t have an account yet? Register yourself now and be a part of our community!