Formula help

keng11

New Member
Joined
Aug 11, 2006
Messages
16
Hi
I used the IF function the eliminate the DIV/0 error as shown in the contracts cell.
AACalculator.xls
KLMN
18Reward & Number of Contracts
190.474701000021.2766
20PremiumTotalRiskContracts
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
KLMN
18Reward & Number of Contracts
190.474701000021
20PremiumTotalRiskContracts
Sheet1


Thank you for your assistance.
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,797
Office Version
  1. 365
Platform
  1. Windows
Try this:
=IF(L19=0,"",INT(M19/L19))
 

Watch MrExcel Video

Forum statistics

Threads
1,113,809
Messages
5,544,415
Members
410,609
Latest member
agarci1096
Top