Originally Posted by
gjames21
Sorry, I made a mistake in my last message - it has been a long day looking a spreadsheets. I had meant to say A1:D1 (ignore my A1 B2 C2 comment).
What I mean is that I said A1:D1 hypothetically but in actual fact my "A1:D1" are: I4, N4, S4, X4, AC4, AH4,AM4 and my "E1" is: AN4
Using this model =E1-IF(A1>0,A1,IF(B1>0,B1,IF(C1>0,C1,IF(D1>0,D1))))
Surely my formula should be:
=AN4-IF(I4>0,I4,IF(N4>0,N4,IF(S4>0,S4,IF(X4>0,X4,IF(AC4>0,AC4,IF(AH4>0,AH4,IF(AM4>0,AM4)))))))
??
But I can't get it to work. I think I have gone number blind, please guide me across the road to safety
Bookmarks