Forum Discussion
Formula Help
In the photo above im trying to create a formula in J3-J5. a quick description. Black pants cost $50 and Tan pants cost $60. but if the person needs XXX-Large pants there is an added $10 fee for anything above XXX-large or higher. So for STEVE i need the formula to calculate the Sum of E5+H5 but i also need it to calculate an extra $10 for steve and anyone else that needs XXX-Large pants but at the same time not adding an extra $10 fee for matt who got a Medium size pant. hopefully this isn't to confusing and any help would be greatly appreciated. Thank you
12 Replies
What are the possible sizes of Pants?
Aside from "XXX-Large", what are the other sizes that require extra $10 fee? Aside from "Medium" and "Large", are there other sizes of that do not require extra $10 fee? For example, are there "Small" and "XXXX-Large" sizes?
