# Formula Help.

#### Joneye

##### Well-known Member
The answer I need is £7.93. My current formula is below.

R4 is my sum, but in order to get to were I want I have to use Column S4 to do additional work, Im sure there is a way I can keep the sum all together?

When I look at =DATEDIF(I4,TODAY(),"M")-72*P4 i get £41.08 It needs to be £7.93, any help would be appreciated.

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### GlennUK

##### Well-known Member
According to your maths so far:
=(DATEDIF(I4,TODAY(),"M")-72)*P4

#### barry houdini

##### MrExcel MVP
You need some extra parentheses......

=(DATEDIF(I4,TODAY(),"M")-72)*P4

#### Joneye

##### Well-known Member
Many thanks worked a treat,

Replies
0
Views
327
Replies
2
Views
284
Replies
22
Views
516
Replies
5
Views
162
Replies
8
Views
465

1,147,743
Messages
5,742,936
Members
423,765
Latest member
PaulD1984

### 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.

### Which adblocker are you using?

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

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