Help needed with % function

[emlo68]

Hi all,

Fairly new to Excel 2007 but I need to create a function to automatically calculate a 3% discount for orders under £1000 and a 5% discount for orders over £1000.

Would be grateful for some help on this.

Many thanks in advance.

[TMS]

Assuming the value is in cell A1:

=IF(A1<1000,A1*3%,A1*5%)


Regards

[Xx7]

Same formula as TMShucks... check the yellow in the attachment.