I believe a saw a posting on this but I was not able to copy and paste the one line formula!!! I want to use a formula like this:
=If B110 <7000, then b109*0.008
B110 is a cell that contains the YTD gross earnings, B109 is the gross earnings for that pay period.
But then I also need this,
=if B110>7000, then b109*0
or something like that. How can I combine both into one formula? Luckily I just have one employee.
=If B110 <7000, then b109*0.008
B110 is a cell that contains the YTD gross earnings, B109 is the gross earnings for that pay period.
But then I also need this,
=if B110>7000, then b109*0
or something like that. How can I combine both into one formula? Luckily I just have one employee.