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?? :(:(:(

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.