Hi everyone

I'm having trouble trying to tweak a spreadsheet for an auctioneer. He has a minimum buyer premium (15%) of £1 so we need a column that shows the minimum of £1 and I've done this with a MAX formula HOWEVER it always shows £1 even if I haven't input a hammer price. I'm assuming that I have to use a couple of hidden column to get to where I want to be but here is my query:-

How can I have a cell show zero if no hammer price is input BUT show the contents of another cell (where the MAX calc is done - Column L) if a value is input.

Hammer price is input in Column F
Buyer Commission is in hidden Col K (=F*0.15)
Min of £1 is shown in hidden Col L (=MAX(1,K...)

I hope that's not too convoluted!!

Jon