<div>
Yes that is correct thank you, I made a minor mistake and you got it right.
</div>


Yes that is correct thank you, I made a minor mistake and you got it right.

<div>
to further simplify by eliminating the if simply replace<br />
<br />
IF(B2=2,3,2)<br />
<br />
by<br />
<br />
(4-b2)
</div>


to further simplify by eliminating the if simply replace

IF(B2=2,3,2)

by

(4-b2)

<div>
<div class="content wysiwyg-content">
Hi,<br />
I’m working with my dad to help him resolve problems in his company, I need to be able to calculate gross pay using IF function.<br />
Dept. 1 employees receive straight time for 40 hours or less and double time for hours over 40.<br />
Dept. 2 employees received straight time for 40 hours or less and Tripe time for hours over 40.<br />
Thank you,<br />
<br />
Name &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Dept. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;Rate &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Hours &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Gross Pay<br />
Sally Wed &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Joe Reed &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Jill Smith &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;44 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />

</div>
</div>


Hi,
I’m working with my dad to help him resolve problems in his company, I need to be able to calculate gross pay using IF function.
Dept. 1 employees receive straight time for 40 hours or less and double time for hours over 40.
Dept. 2 employees received straight time for 40 hours or less and Tripe time for hours over 40.
Thank you,

Name	                  
                         Dept.	       Rate	         Hours	                   Gross Pay
Sally Wed          1	           10	             20	 
Joe Reed	     2	           10	             50	
Jill Smith	      1	           20	             44	



Excel 2010 IF function

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.