Formula Depending on a value

[likeatiger81]

Hi All,

i have a sheet which is being used as a payment advise with subsidies.
depending on the product selected, it is either a $value multiplied by the qty or a % of the total value.

what i am trying to do as an example:

if cell F46 = percent(or sheet2 b6) it needs to multiply by cell H32

BUT if cell F46 = $ (or sheet2 B7:B11) it needs to multiply by cell B46

(sheet 2 has named ranges to be used in a list box)

Any help on the matter would be greatly appreciated.

Cheers

 

[likeatiger81]

LEGEND!!

thanks again MD