16th January 2013, 07:51 PM
|
|
Suspended
|
|
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
|
|
Quote:
|
Originally Posted by enjay
It is a target staking plan whereby 1-6 is my target of 40.
|
I don't understand this statement.
Is the current bank in Column "I"?
Is the current target in Column "K"?
Is the target ALWAYS $40 even if you have won $20 of it?
I think you would need to add MAX to your Formula somewhere.
Along these lines , as I ain't got enough data.
=IF((MAX(I1:I47))-K47)<40,(40),(I47-K47)) |