I'm trying to create a fee calculator but I can't seem to get the formulas to work for me. I'm essentially trying to write one long formula that takes into account all of the different date variables. I have six selectable products and I've been trying to use a combination of IF, AND and OR statements.
My columns are set up like this:
List of products:
Product 1
Product 2
Product 3
Product 4
Product 5
Product 6
I want the formula in C2 to retu:
"No" under "Fee Payable" for the following:
"Yes" for the following:
I would like C2 remain blank until something is entered into A2.
برچسب:
نویسنده: استخدام کار