I am trying to create a formula that will allow several options, here are the options

<85% = the cell times .12
>85% = 100% the cell times .15
>100% = 110% the cell times .20
>110% the cell times .30

Hi

Assuming cell A1 is 'the cell' in question then try this in the cell where you want the answer

=A1*IF(A1>1.1,0.3,IF(A1>1,0.2,IF(A1>0.85,0.15,0.12 )))

This assumes that A1 is a decimal formated as a percentage, (ie 1 dispays as 100%).


HTH

MTB