Hello everyone,

This is driving me nuts so can someone help, please? lol

This is what I'm trying to achieve as a function in a cell, which has a (£) figure being calculated into it.

3% of purchase or 4K whichever is greater

So, for example...

The figure can never go below £4K, but if the [cell containing purchase price] works out to be more than 4K based on 3% of [cell containing purchase price] use the 3% figure it will be greater than 4K.

Hope I explained that correctly lol

Many thanks in advance from a newbie