Ask Experts Questions for FREE Help !
Ask
    NEENOR's Avatar
    NEENOR Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Oct 3, 2008, 03:33 PM
    Damsel in Distress re formuleas for severance payments
    I'm at my wits end trying to figure this out. I want to know what formula to put in if I am caculating severance payments based on years and months service. I have managed to figure out how to calculate the years, but am stuck on calculating the months. What I want to know is how to input the following as formulea:

    If cell f7<6months then payment is 0, if f7>6months then payment is 2*cell f5

    Can anyone help me... please?? :(:(:(
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Oct 3, 2008, 07:21 PM

    Code:
    =IF(F7<6,0,2*F5)
    If you want cell F7 to show the word "months" IN the cell, you will need to use a formatting trick. You need to just type whole numbers in the cell itself. I can show you that trick, too, if you want.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Severance Pay [ 3 Answers ]

I received 3 weeks severance pay from my company that I was laid off last July. The company sent my W-2, but I didn't receive a severance form from them. Neither did the others I asked that were also laid off. So? Does that mean then I shouldn't worry about it?

Negotiation of a severance package [ 5 Answers ]

My husband was recently fired from a very lucrative position based on a false allegation. Rather than investigate the allegation, the executive fired him, had him forcibly removed from his office, and removed him from the company website. That was Thursday. The decision to fire my husband was...

Severance Pay [ 3 Answers ]

My former employer has defaulted on our signed severance agreement by having insufficient funds for my severance check to clear. In other words, my severance check bounced. I have notified the District Attorney's office and the Department of Labor. Can I file a summons and complaint and have him...

View more questions Search