Formula that i can get a total for D7, if D7= D4 + (C6*D7) [Solved/Closed]

Report
Posts
2
Registration date
Thursday August 28, 2014
Status
Member
Last seen
August 29, 2014
-
Posts
2
Registration date
Thursday August 28, 2014
Status
Member
Last seen
August 29, 2014
-
$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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Thursday August 28, 2014
Status
Member
Last seen
August 29, 2014

Thank rayh! This seemed to work!