Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function
I have a new problem, how do I type the If formula for this one
the formula is to calculate 401K contributions for employees. The formula should determine the number of years employed in column C is greater than or equal to 1, then the contributions is equal to the contribution percentage of 3% located in column F4 multiplied by the employee salary in column D, otherwise the contribution is zero. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function
potsie wrote:
I have a new problem, how do I type the If formula for this one the formula is to calculate 401K contributions for employees. The formula should determine the number of years employed in column C is greater than or equal to 1, then the contributions is equal to the contribution percentage of 3% located in column F4 multiplied by the employee salary in column D, otherwise the contribution is zero. I forgot to mention this has to also be in the round function |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function
Try: =IF(C4<1,0,D4*F4) and copy to other cells in column -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=531729 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function
This rounds to 2 decimal places. Is this what you want? Otherwise can you explain more clearly. =IF(C4<1,0,ROUND(D4*F4,2)) -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=531729 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |