Having an issue with how to write a slightly complicated SUMIF formula

Hi,

I need a formula to solve if the sum of two cells is more than a specific number then I want it to add the 2 cells plus add 3% (I'm guessing it's Cell1:Cell2*1.03) for the percentage bit? but it's the IF bit that I'm not sure about to get it to calculate what I want it to calculate.

e.g. if A1 = £4000 & A2 = £4000 & B1 = £5000 and B2 = £5000, I want a formula in A3 to calculate the sum of A1 & A2 plus 3% only if the sum of the 2 cells is more than 9000. If it's less than or equal to £9000 then I just want the sum of the 2 cells. And the same in B3 for calculating B1 & B2. So basically A3 should equal £8000 (A1 + A2) and B3 should equal £10,500 (B1 + B2 + 3%).

I've added a screenshot to show what I want it to do. I need the formula in cell E3 for calculating C4 & D4 and in H3 for calculating F4 & G4 etc etc.

Excel Formula Problem.jpg

Hope the above makes sense. Any help will be greatly appreciated.

Thanks,
Sally

Aha, thank you so much. I knew it needed all that in it and knew roughly what it need d to look like, but I just never know what order it's all supposed to go in and exactly how to write the formula for it to work properly. The above formula works perfectly, thank you