# Simpleish If formula i hope..

#### fatreg

##### Board Regular
Hi people,

I'm trying to calculate a monetary value based on weekly amout and there maybe an uplift or not.

Essentially, weekly pay is capped at 464 a week, there can be a % uplift in the total, this can then be multiplied to give a number of weeks.

I feel like a right chump but it's stumping me!

</SPAN>
576.92
Weekly
24
Amount of Weeks
10%
Uplift
 14959.68

<TBODY>
</TBODY>
Total

<TBODY>
</TBODY>
</SPAN>
</SPAN>
</SPAN>In A4 in the above example I have =IF(A1>464,SUM(464*A3+A1)*A2,SUM(A1*A3+A1)*A2)

Yet, on my trusty calculator I make it

464*10%+464 = 510.40

x24 = 12249.60

Why the difference? What am I doing wrong in excel?

Please help! my job doesn't quite depend on it, but my sanity does!



<TBODY>
</TBODY>
</SPAN>

<TBODY>
</TBODY>

### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

#### bbott

##### Well-known Member
You're adding 576.92 (A1) in your table example, but in your hand calculated formula, you're adding 464.

=IF(A1>464,SUM(464*A3+A1)*A2,SUM(A1*A3+A1)*A2)

464*10%+464 = 510.40

#### JRosa

##### New Member
You're not doing the same math on the calculator as in the formula. Formula says (464*.1+576.92)*24

#### Snakehips

##### Well-known Member
Incorrect interpretation - Removed Snakehips

Last edited:

#### shg

##### MrExcel MVP

One possible interpretation of what you said:

 A​ B​ 1​ \$ 576.92​ Weekly 2​ \$ 464.00​ Max 3​ 24​ Weeks 4​ 10%​ Uplift 5​ \$ 12,249.60​ A5: =MIN(A1, A2) * A3 * (1+A4)

#### fatreg

##### Board Regular
thanks chaps/chapesses.

told you I was being dim!

thanks Shg, I like that! future proof too, update one box..

#### shg

##### MrExcel MVP
You're welcome.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,990
Messages
5,834,752
Members
430,317
Latest member
karenmi

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back