Formula needed

[BassinghamTerrier]

Hi all

I'm a newbie with what, for you, will be a simple task.

In the picture here I need cell B25 to ONLY show a 10% discount if the figure in B24 EXCEEDS £200.

How do I do it, please?

Thanks in advance for your time and consideration. :smiling_face_with_smiling_eyes:

[#2]

Sorted it myself now. =IF(B24>200,B24/10,"£0.00")

[#3 · Accepted solution]

@BassinghamTerrier 

I'd use

=IF(B24>200,B24/10,0)

The number format will display 0 as £0.00