Previous Topic Next Topic

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
Related:

2 responses

Answer 1 / 2
rayh
Aug 28, 2014 at 10:15 PM
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
Answer 2 / 2
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses