Is it possible to create one formula in one cell, say C15, that is conditioned upon the following:
If C8 is less than or equal to 30,000 then C15 * .06,
If C8 is between 30,001 and 39,999 then C15 * .08,
If C8 is between 40,001 and 49,999 then C15 * .10,
If C8 is greater than 50,000 then C15 * .12
Please advise.
Thanks.
If C8 is less than or equal to 30,000 then C15 * .06,
If C8 is between 30,001 and 39,999 then C15 * .08,
If C8 is between 40,001 and 49,999 then C15 * .10,
If C8 is greater than 50,000 then C15 * .12
Please advise.
Thanks.