Below are the conditions and the desired return value if conditions are met:
My table looks like
<tbody>
</tbody>Here are the conditions. These conditions only apply if GM$ & GM% are above $25 or 25%. If GM% & GM$ aren't above = or more than 25 the cell should return $0 in dues.
<tbody>
</tbody>
Can I use VBA to assess whether these conditions are met and return the desired value? Example: assuming GM$ & GM% are met at 25 then if status is = Term<60 and Type = Emp then I would like the cell to return $1,333 value. How can I make this possible?
Please help with formula. Thank you!
My table looks like
Status | Type | GM$ | GM% | Dues |
<tbody>
</tbody>
Status | Type | Dues |
Pending | Emp | 4000 |
Term<30 | Emp | 0 |
Term<60 | Emp | 1333 |
Term<90 | Emp | 2000 |
Pending | C2C | 1500 |
Term<30 | C2C | 0 |
Term<60 | C2C | 500 |
Term<90 | C2C | 1000 |
<tbody>
</tbody>
Can I use VBA to assess whether these conditions are met and return the desired value? Example: assuming GM$ & GM% are met at 25 then if status is = Term<60 and Type = Emp then I would like the cell to return $1,333 value. How can I make this possible?
Please help with formula. Thank you!