# Round function question

#### IrishHawg09

##### New Member
I'm trying to create a formula that, based upon yearly revenue, we are able to automatically calculate how much in insurance my company will likely need.

Here's what we have:

Insurance, blocks of \$1,000,000 coverage @ \$2,000.00 a block
Revenues exceed \$1mil annually

Formula I'm using:

=IF(Yearly Revenue<1000000,2000/12,ROUND(((Yearly Revenue/1000000)*2000)/12,5))

Revenue for year 3 is \$3,546,875.00, so the amount of insurance should be \$8,000.00 annually, or \$666.67 a month, but its getting an amount of \$591.15. Obviously, this is wrong.

Thanks!

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Try
Code:
``=IF(Yearly_Revenue<1000000,2000/12,CEILING(Yearly_Revenue/1000000,1)*2000/12)``

Replies
1
Views
369
Replies
1
Views
871
Replies
1
Views
2K
Replies
2
Views
496
Replies
9
Views
11K

1,196,357
Messages
6,014,760
Members
441,847
Latest member

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