ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   IF function (https://www.excelbanter.com/excel-discussion-misc-queries/82575-if-function.html)

potsie

IF function
 
Can someone help me asap with a formula in the IF function, it is to
caluclate 401k contributions for employees. The formula should determine that
if the number of years employed in column C is greater than or equal to 1,
then the contributions is equal to the contibution percentage of 3% in column
F4 multiplied by the employee salary in column D, otherwise the contribution
is zero. This has to also be in the round function, help.

John James

IF function
 

Already posted, please don't open multiple threads for the same issue -
keep it within the one thread.

refer http://www.excelforum.com/showthread.php?t=531729


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531734



All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com