SOLVED

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?

 

query.jpg

 

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)
Solution

@BassinghamTerrier 

I'd use

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

The number format will display 0 as £0.00