Nested IF limit problem

[rjw]

Hi,
I am having difficulty with what initially seemed a simple problem until I exceeded the nested IF limits

Please see attached spreadsheet, I have explained the problem I am having on the spreadsheet.

Many thanks in advance for your help

[DonkeyOte]

Welcome to the Board.

Does this work for you ?

G3: =IF($F3=0,0,IF($G2,$G2,LOOKUP(2,1/($G$2:$G2<>0),$G$2:$G2)*-1))
copy down as required
(note for your own regional settings you may need to alter syntax re: use of semi-colon etc...)

[arthurbr]

Donkey,
it seems to go wrong from G27 on

Sorry, it's OK np.

[DonkeyOte]

[removed in lieu of Arthur's edit]

[arthurbr]

Was correcting my post while you were typing

[zbor]

@Donkey, you could leave explanation.. It was interesting and educating

@arthurbr: you can't put "to go wrong" and "Donkey" in same sentence

[arthurbr]

arthurbr: you can't put "to go wrong" and "Donkey" in same sentence

That's why I added "seems" ( to avoid the "kick of the mule")

[DonkeyOte]

@arthurbr: you can't put "to go wrong" and "Donkey" in same sentence

Don't make me out to be like that zbor you'll get me a bad rep...I've already had one member here accuse me of profound arrogance in the last week!
apparently it is perfectly understandable as to why no one is presently employing me ...

[arthurbr]

Hope he was joking, Donkey !
To be on the safe side I already added to your well-deserved reputation

[zbor]

I've add rep this morning as soon as I saw it's working since I've lost half hour without result trying to solve it

[rjw]

Many thanks DonleyOte, that worked just fine, congratulations on such a speedy reply!

rjw