# Software

## General discussion

Locked

### Using thew value of one Excel Formula in another cell

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

Thread display: Collapse - | Expand +

## Related Discussions

• 0

• 1

#### What is Inventory Optimization?

social1545816808 ·

• 0

#### About Best Customer Relationship Management (CRM) Software.

priti1603775985 ·

• 1

rebapelo ·

• 0

Lcannon4 ·