# Formula help

#### keng11

##### New Member
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
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
Sheet1

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
Try this:
=IF(L19=0,"",INT(M19/L19))

Gday Peter,
Nailed it thanks.

Replies
1
Views
142
Replies
1
Views
104
Replies
4
Views
269
Replies
2
Views
315
Replies
5
Views
241

1,219,970
Messages
6,151,215
Members
451,017
Latest member
peterlam84

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