I think I'm just missing something obvious here but I want to calculate commission based on £1 Plus 10% of Hammer Price. That bit's easy but I need it to ignore the hammer price if blank. In other words if I leave the hammer price empty, at the moment the sheet adds £1 to the commission cell.

In Summary:-

F3 is Hammer Price
K3 is Commission (=(F3*.1)+1)

K3 should NOT state £1 if F3 is empty

Can anyone help?

Jon