Forum Discussion
Excel Table Autofill using IF() Statement
I'm trying to build a table in Excel that uses IF() statements to apply different formulas to the same cell based on characteristics in a cell at the top of the page, but running into issues as the c...
You need some extra columns:
Flat rate
Discount %
Rate new
In "Flat rate" and "Discount %" you type your overriding values.
Formula in "Rate new":
=IF([@[Discount %]],[@Rate]*(1-[@[Discount %]]),IF([@[Flat rate]],[@[Flat rate]],[@Rate]))