Adding Rounding to Insurance calculation w/ prorata values

[OH650R]

I have a base formula that calculates the beginning and expiration date including the effective date of the change (insurance related). It spits out a prorata figure simplified to 3 digits, but it's really however many decimals it takes to calc. I'm hoping to use the ROUND functiion inserted into the current formula to simplify it if possible to point (.000) decimal places. Just not sure how to incorporate. Thanks in advance! Formula is as follows: =IF(E20=0;1;IF(((D20-A20)/365)>1;1;(D20-A20)/365)). How can I take the result of the current formula to have a rounded 0.123 result?

 

[StephenCrump]

Welcome to the Forum!

Try:

=IF(E20=0;1;MIN(1;ROUND((D20-A20)/365;3)))

 

[OH650R]

Welcome to the Forum!

Try:

=IF(E20=0;1;MIN(1;ROUND((D20-A20)/365;3)))

Thanks for the welcome! I get too few arguments error with this formula.

 

[felixstraube]

replace ";" with ",".

 

[OH650R]

replace ";" with ",".

Yes, I tried that too.

 

[felixstraube]

This is working fine for me:

Book1
	A	B	C	D	E	F	G	H	I
19								Old	New
20	1.23564			356	1			0.971957	0.972
Sheet1

Cell Formulas
Range	Formula
H20	H20	=IF(E20=0,1,IF(((D20-A20)/365)>1,1,(D20-A20)/365))
I20	I20	=IF(E20=0,1,MIN(1,ROUND((D20-A20)/365, 3)))

 

[OH650R]

This is working fine for me:

Book1
	A	B	C	D	E	F	G	H	I
19								Old	New
20	1.23564			356	1			0.971957	0.972
Sheet1

Cell Formulas
Range	Formula
H20	H20	=IF(E20=0,1,IF(((D20-A20)/365)>1,1,(D20-A20)/365))
I20	I20	=IF(E20=0,1,MIN(1,ROUND((D20-A20)/365, 3)))

I copied yours and it did work...thank you! I must have buggered up the other one when I was replacing : with ,
Cheers