amend lay amount formula

hi,
can someone help me amend the following formula to
bet minimum of 5 should calc result show a fig less than 5

(((expectation * (lay_price - 1)/divisor)*base/(lay_price-1)))

I thought the following should work but doesn't

IF((((expectation * (lay_price - 1)/divisor)*base/(lay_price-1)))<5,5,(((expectation * (lay_price - 1)/divisor)*base/(lay_price-1)))

thanks
R

Hi
IF((((expectation * (lay_price - 1))/divisor)*base)/(lay_price-1)<5, 5, (((expectation * (lay_price - 1))/divisor)*base)/(lay_price-1))

I was almost there

Thanks Mark

amend lay amount formula

Hello Guest