Excel help

[Cod3waX]

ok i got the basics i just need some configuring help

ok in a column is and total to deduct 10% but i want to make this able to control 2 commands

so i want it to -10% up to ?75

so i want it to put ?75 in the column if the -10% is greater than ?75 if its not then i want it to do its normal -10% deduction

cheers for ay info and help

[Spacerat]

Try this - this assumes your data is in Column A

=IF(A1*0.1>75,75,A1*0.1)

It basically says if the value in A1 times the discount (10%) is greater than 75 then make the discount 75, else the discount is 10%.

Is that what you were trying to do?

[Cod3waX]

Try this - this assumes your data is in Column A

=IF(A1*0.1>75,75,A1*0.1)

It basically says if the value in A1 times the discount (10%) is greater than 75 then make the discount 75, else the discount is 10%.

Is that what you were trying to do?

That is spot on thank you

[Spacerat]

You're welcome