# formula needed

#### Bourgeois

##### New Member
What would the formula be for this equation.

A1 = Salary of 20,000
A4 = Salary * 2 rounded to the next 1000.00

Thanks,

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
So, would you want the answer to be 41, 000 ?

yes

=round((a1*2),-3)

edit: sorry posted too quickly, this rounds to nearest thousand

here is a new salary...

A1 - salary is 34671.00
A4 - Salary *2, then rounded to the next 1000.00

Answer in A4 should be 70,000

One way

=CEILING(((A1*2)+1),1000)

Right, but if the salary (A1) was 0.00 then it would show 1000.00. I am calculating a Basic Group Life Salary, which is 2 times their regular salary rounded to the next thousand. But if the person is off work, and I input a 0.00 salary... I still don't want anything to show up?

=if(a1=0,0,CEILING(((A1*2)+1),1000))

Try =CEILING(A1,1000)...

Amended: =CEILING(A1*2,1000)

Last edited:
Or

=IF(A1=0,0,IF(MOD(A1,1000)=0,CEILING((A1*2)+1,1000),CEILING(A1*2,1000)))

Replies
2
Views
372
Replies
0
Views
149
Replies
9
Views
217
Replies
4
Views
367
Replies
1
Views
397

1,203,537
Messages
6,055,988
Members
444,839
Latest member
laurajames

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