I am working on a incentive pay out formula but got stuck how to use a cap value of 3500/-in the under mentioned formula for some one who has achieved more than 110% .I want to set for 111% Ach this formula should show Rs 3500/- =IF(F7<100,0,IF(F7=100,2500,IF(F7>=101,2500+(F7-100)*1*100))) Please help to solve this problem
