Hello.

I am trying to create an IF statement which will validate the data in one cell & then check the data against another rule, if the second rule is true then ignore the first rule

For example if criteria exists in the first cell ie certain letters of text then take the sum of another cell & provide the sum (which is 75% of the amount in that cell & at the same time check to make sure the result is not more than a certain amount, it is is then ignore the first result/validation & use the second result/validation)

[TABLE="width: 655"]

[tr]

[td]

Quantity

[/td]

[td]

Item number(s)

[/td]

[td]

Spec Code

[/td]

[td]

Item Charge/Quote

[/td]

[td]

Total Charge

[/td]

[td]

Rebate (as per schedule)

[/td]

[td]

Extended Rebate

[/td]

[td]

Conditions

[/td]

[/tr]

[tr]

[td]

2

[/td]

[td]

881

[/td]

[td]

SPE2

[/td]

[TD="align: right"]$200.00[/TD]

[TD="align: right"]$400.00[/TD]

[TD="align: right"]$20.00[/TD]

[td]

$ 300.00

[/td]

[td]

SP 70% up-to $98.00 per item

[/td]

[/tr]

[tr]

[td]

1

[/td]

[td][/td]

[td][/td]

[TD="align: right"]$20.00[/TD]

[TD="align: right"]$20.00[/TD]

[TD="align: right"]$10.00[/TD]

[td]

$ 10.00

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$20.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$20.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$20.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$20.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$20.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$20.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[TD="align: right"]$0.00[/TD]

[td]

$ -

[/td]

[td]

[/td]

[/tr]

[/TABLE]

Hello Just to clarify Cell with quantity is A, Item number is B, Spec Code is C, Item Charge/Quote is D, Total charge is E, Rebate as per schedule is F, Extended rebate is G, Conditions is H & Limits is I

So my original question is I have an if statement which is in G which which takes the sum which calculates 70% of E. The first code in C creates a condition in H. At the moment I have result being created in G based on E 70% I want the result in G to be limited to no more than $98.00 even if the result is more an than 70% of E