Hi,

I have been trying to sort this out for a while and have copied an pasted examples i have found on the net and edited them to fit my situation but no luck!!

Heres the deal...

I have in cell C13 a drop down menu with three options 'Buy Now' 'Buy Now Existing' 'Auction'. In cell I12 i need a function so that if C13 = Buy Now I12 = 0.40, If C13 = Buy Now Existing I12 = 0, if C12 = Auction I12 = 0.10.

The best I have come up with is this but it doesnt work .... =IF(C12="Buy Now",0.4,IF(C12="Buy Now Exsisting",0,IF(C12="Auction",0.1)))


PLEASE HELPP

Many Thanks!