Forum Discussion
Help me with a formula Please
I am working on a order form. I need a Sub Total based on tiered pricing. You enter a quantity into column E. This # is multiplied by Colum D, that # is multiplied by either H, I or J if is is > than...
If you have access to LET, you could use:
=LET(
product, E16 * D16,
multiplier, XLOOKUP(product, $G$15:$I$15, G16:I16, 1, -1),
product * multiplier
)