Hi all,

I've received some input here which has been helpful but I find myself
running into a bit of a brick wall and I hope someone can help.

Here is my formula.

IF(C43<1.2(AND(D43={"D","E","F"}),AND(E43={"IF","V VS1","VVS2"})),F43-(F43*0.04,IF(AND(C43<1.2,AND(D43={"D","E","F"}),AN D(E43={"VS2","VS2"})),F43-(F43*0.08),F43-(F43*0.15)))

To spell it out for ya ... C43 contains a numeric value, D43 contains alpha
numeric characters as well as E43. If columns C, D and E contain certain
values I want the discount from F43 to show certain values in the cell where
I place the formula.

Your help is appreciated.

Jonathan