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

[jasontx39]

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

 

[Tetra201]

Try using =(C2-B2)/365

 

[jasontx39]

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]

Maybe just wrap your formula in ABS()?
=ABS(your-formula)

 

[wwbwb]

Try this:

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

 

[jasontx39]

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