formula needed

[Bourgeois]

What would the formula be for this equation.

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

Thanks,

 

[SteveO59L]

So, would you want the answer to be 41, 000 ?

 

[Bourgeois]

yes

 

[doofusboy]

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

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

 

[Bourgeois]

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

 

[SteveO59L]

One way

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

 

[Bourgeois]

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?

 

[SteveO59L]

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

 

[Sigh]

Try =CEILING(A1,1000)...

Amended: =CEILING(A1*2,1000)

 

[SteveO59L]

Or

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