Dear all

Help

I need a formulae that will kick in after various criteria is met. Rule 1: If A is met then the answer is 75, if rule B is met then the answer is 15% of cell C1 with a min of 175 and a max of 250 applying, if rule c is met then the answer os 20% of C1 with a min of 200 and a max of 250 applying.

I know the formulae =IF(C23 * 0.15 < 175, 175, IF(C23 * 0.15 > 250, 250, C23 * 0.15)), will help me if rule b was the only rule but am having trouble with the rest.

Any help would be truly appreciated!!!!!