Re: adding 5% and round off the result

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: aboiy (aboiy422_at_hotmail.com)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 07:50:27 -0700

Hi Frank,

the date formula works great.

about my first question i dont know how to call it but
there should not be any fraction when the 5% is added to
the basic salary.

 Basic +5% Result Correct
 7,500 375 7,875 7,880
 5,545 277 5,822 5,830
 8,750 438 9,188 9,190
 4,575 229 4,804 4,810

>From the above example, the "result" col.has a fraction of
5,2,8,4 at the end of the figure, it should be added so
that the end figure will be "0".
                
Hope you understand what i mean.

Regards,

aboiy

>-----Original Message-----
>Hi
>not sure about your first question about adding up
to '10' but for your
>second question use something like
>=IF(B1<=TODAY()+5,ROUND(C1*1.05,2),C1)
>
>with B1 your contract date
>
>
>
>--
>Regards
>Frank Kabel
>Frankfurt, Germany
>
>
>aboiy wrote:
>> Hi Frank,
>>
>> Once again thanks for the tip, referring to my question
is
>> it possible also that the result will add up to 10's to
>> the resulting figure.
>>
>> 5,985 should be 5,990
>> 4,515 should be 4,520
>>
>> My second question is about the formula for the date, is
>> there a way to calculate the contract date base on the
>> present date, =today(). Let say if someone contract is
>> expiring 5 days from now can it calculate salary by
adding
>> 5% from its basic salary.
>>
>> Thanks in advance.
>>
>> aboiy
>>> -----Original Message-----
>>> Hi
>>> try
>>> =ROUND(C1*1.05,2)
>>>
>>> --
>>> Regards
>>> Frank Kabel
>>> Frankfurt, Germany
>>>
>>>
>>> aboiy wrote:
>>>> Hi,
>>>>
>>>> Is it possible to make a formula wherein the basic
salary
>>>> of the employee will automatically increase to 5% upon
>>>> reaching his contract expiration, but if the amount
should
>>>> be roundoff.
>>>>
>>>> Ex. A B C D
>>>> Name Date Hired Basic Salary New Rate
>>>> George Cloone 15.Sep.00 5,700 5,985
>>>> Saman Martinez 23.Aug.02 4,300 4,515
>>>>
>>>> Where column "D" results should be round off to:
>>>>
>>>> New Rate
>>>> 5,985 should be 5,990
>>>> 4,515 should be 4,520
>>>>
>>>> For your kind assistance.
>>>>
>>>> Thanks in advance
>>>>
>>>> aboiy
>>> .
>
>.
>

Relevant Pages

  • Re: adding 5% and round off the result
    ... Hi Frank, ... Once again thanks for the tip, referring to my question is ... Let say if someone contract is ... >aboiy wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: adding 5% and round off the result
    ... aboiy wrote:> Hi Frank, ... > My second question is about the formula for the date, is> there a way to calculate the contract date base on the> present date, =today. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Buttongate II Over?
    ... >Oh dear, Frank, you don't seem to know a lot about contracts. ... >Frank had an ironclad contract with JB, if he really would lose-out on ... you honestly think he would have been an "asset" and more importantly, ... Let's not forget that as binding as the ...
    (rec.autos.sport.f1)
  • Re: Buttongate II Over?
    ... >> Oh dear, Frank, you don't seem to know a lot about contracts. ... >> Frank had an ironclad contract with JB, ... As he has done at BAR. ... but I was never a Prost fan and there are those in the current ...
    (rec.autos.sport.f1)
  • Re: OT - Obamanomics
    ... contract is not expanded she is laid off. ... Frank Howell- Hide quoted text - ... during the Bush years then vote Republican candidates in; ... LOL, dm_callier ignores the question, "What are the Democrats plans ...
    (rec.outdoors.rv-travel)