good morning.

i've got a pricing spreadsheet that's doing my head in. hopefully someone can help me with my latest formula issue.

when i expor the file as a pdf, you loose the column names. so...

a b c d e f g h
part ID qty 1 price qty 2 price qty 3 price discount price

i want to calculate the discount price as a perctange of either b/c or d/e or f/g groupinsg (qty break & price for that paricular qty amt). The problem is b/c are populated for all rows. some parts have a secdonary price break (d/e) and some have a tiertary price break (f/g).

I want to take the percentge discount off the high qty price break. So if f/g is populated I want to take it from that. If it's not populated, then e/f. and Only if f/g & e/f are NOT populated do i want to take the discount from b/c. is there a formula i can insert into H to do this?

(i hope i've explained this well) thanks in advance.