General discussion

Locked

Using thew value of one Excel Formula in another cell

By eakff2002 ·
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

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums