Formula help

[keng11]

Hi
I used the IF function the eliminate the DIV/0 error as shown in the contracts cell.

AACalculator.xls
	K	L	M	N
18	Reward & Number of Contracts
19	0.47	470	10000	21.2766
20	Premium	Total	Risk	Contracts
Sheet1

Then I changed it to the FLOOR function to eliminate all the numbers after the decimal point. Is there a way to achive both results ( no error & no numbers after the decimal point).

AACalculator.xls
	K	L	M	N
18	Reward & Number of Contracts
19	0.47	470	10000	21
20	Premium	Total	Risk	Contracts
Sheet1

Thank you for your assistance.

 

[Peter_SSs]

Try this:
=IF(L19=0,"",INT(M19/L19))

 

[keng11]

Gday Peter,
Nailed it thanks.