multiply if

Hi guys! I have a table ("B:G") where the column headers are weeks ("C:E"). And in column G I have different dynamic values. I am trying to multiply the values in range C:E if the criteria in column B is met. So, in short this is what I am trying to do: If value A1 = "dollar" and If column...

I've tried to find an answer here but I actually don't know the correct name (if there is one) for this formulation. What I'd like to do is multiply a cell by say 10% but only if the cell is equal/less than $100.... or... multiply by 5% if the cell is greater than $100. I have a range of...

I need to multiply different percentages based on the dates in another row. I have a table that looks like this: Vacancies - % - Start Date Yr 1 - 20% - 1/1/18 Yr 2 - 10% - 1/1/19 Yr 3 - 10 % - 1/1/20 Yr4 & Beyond - 8% - 1/1/21 Then another worksheet that has 40 years of...