Trying to get two formulas for one cell for a created estimate.
For example: D12 represents units/amounts with a data validation list from 1-10, while F12 represents the total fee. The formula is D12*625.
I shortly realized there are times a discount is given.
Therefore, E12 will represent 10%, 20%, and 30%- how can I keep the same formula for the total fee while adding a discount?
Bookmarks