Formula needed

New Contributor

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.

2 Replies
Sorted it myself now. =IF(B24>200,B24/10,"£0.00")
best response confirmed by BassinghamTerrier (New Contributor)


I'd use


The number format will display 0 as £0.00