Looking for help on expanding on the following formula in excel:
=IF(LEFT(C6,1)="B",S6/(1-$Y$3),(S6/(1-$Y$4)))
I need to check cell C6 to see if it starts with a B and then apply a % increase based on whether it does or doesn't start with a B.
I now want to check cell C6 and match the category in D6 to a separate list, and apply the % increase accordingly.
Is that possible?
Solved by S. B. in 25 mins