I am looking for a formula to calculate a cell. I cannot come up with the proper formula. It has multiple parts:
Cell Range: A1:B1 (Sum)
-5% on first $100
-Over $100....2% up to $95
This cell is to never be over $100.00. I have tried this with some nested if statements but have had little success. Any assistance would be great.
Cell Range: A1:B1 (Sum)
-5% on first $100
-Over $100....2% up to $95
This cell is to never be over $100.00. I have tried this with some nested if statements but have had little success. Any assistance would be great.