# I need to multiply a .0756 as a positive number and not as a negative number

#### jasontx39

##### New Member
I need to multiply a .0756 as a positive number and not as a negative number. Excel sees this as -0.756, instead of 0.756. Why am I getting .756 as a negative when it is greater than zero?

 Data 1 Start Date End Date =(B2-C2)/365 =A2*D2 408.00 5/1/2017 2/1/2018 -0.756 308.52

<tbody>
</tbody>

Should be
408.00 x .756 = 308.448

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

#### Tetra201

##### MrExcel MVP
Try using =(C2-B2)/365

#### jasontx39

##### New Member
Try using =(C2-B2)/365

=(C2-B2)/365 does change it to a positive number, but I still get 305.52 , when i need to get 308.45

 Data 1 Start Date End Date =(C2-B2)/365 =A2*D2 408.00 5/1/2017 2/1/2018 0.756 308.52

<tbody>
</tbody>

Should be
408.00 x .756 = 308.45

#### FDibbins

##### Well-known Member
Maybe just wrap your formula in ABS()?
=ABS(your-formula)

#### wwbwb

##### Well-known Member
Try this:

=ROUND((C2-B2)/365,3)

#### jasontx39

##### New Member
Try this:

=ROUND((C2-B2)/365,3)

=ROUND((C2-B2)/365,3) worked. Thank you

 Data 1 Start Date End Date =ROUND((C2-B2)/365,3) =A2*D2 408.00 5/1/2017 2/1/2018 0.756 308.45

<tbody>
</tbody>

Should be
408.00 x .756 = 308.45

Replies
5
Views
514
Replies
1
Views
523
Replies
1
Views
947
Replies
4
Views
1K
Replies
1
Views
805

1,195,671
Messages
6,011,076
Members
441,581
Latest member
rp4717

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