In Cell B2 I need to enter # of hours worked
Cell B3 is the formula =B2*28.084
Cell B13 is the problem cell. It uses the following Nested IF formula:
Here is my issue.
In my worksheet I need to enter # of hours worked in cell B2
Cell B3 is the formula =B2*28.084
This part works fine. However in Cell B13 It nees to calculate the tax amount.
The formula in cell b13 is a nested If statement and is:
=IF(($C$2<=800),(C2*0.1),IF((C2<=1300),(C2*0.15),IF((C2<=1400),(C2*0.16),IF(($C$2<=1500),(C2*0.17),"")))) What is happening is that Cell B13 is always blank. If I change Cell B2 and just type the value cell B13 works. How can I get my formula in Cell b13 to evaluate the result of the formula in cell B3? Thank you