There isnt anything in the worksheet yet, its done in our heads which is one of the reason that I am trying to set the excel up, I'll try to explain again.

I woudl like to have a cell with a data validation list, listing A, B & C.
If my collegaue selects A, then the answer in the formaulated cell will be £75, if they select B then the answer will be 15% of the price in cell C1, but it will have a min of £175 and a max of £250 should the 15% be lower or greater, if they select C then it will be 20% of the price in cell c1 and again min of 200 and max of 250 come into play.

Hope you can help