Hi, I have the following formula which uses an IF statement to validate whether to perform a calculation and I need to set a minumum value. The formula is:

=IF(LEFT(A108,3)="cmb",E108*0.05,0)

If Cell A108 begins with CMB then the rate to apply is E108*0.05 but if E108 is less than 400 I need the result to be 20.

Any help appreciated