Formula that i can get a total for D7, if D7= D4 + (C6*D7)

Solved/Closed
dmadden
Posts
2
Registration date
Thursday August 28, 2014
Status
Member
Last seen
August 29, 2014
- Aug 28, 2014 at 06:45 PM
dmadden
Posts
2
Registration date
Thursday August 28, 2014
Status
Member
Last seen
August 29, 2014
- Aug 29, 2014 at 11:28 AM
$1,613.00 (Cell D4)
(C6)
Hours ___ $175.00 (D6)

TOTAL (D7)


Can any one tell me a formula that i can get a total for D7, if D7= D4 + (C6*D7) only if there is a number greater than zero in cell C6. This formula will give a daily total if a subcontractor works over 10 hours per day. Thanks

2 replies

in cell D7

=IF(C6>0,D4+(C6*D6),"")

I assume you meant D6 in the formula as using D7 causes a circular reference
1
dmadden
Posts
2
Registration date
Thursday August 28, 2014
Status
Member
Last seen
August 29, 2014

Aug 29, 2014 at 11:28 AM
Thank rayh! This seemed to work!
0