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

Formula that i can get a total for D7, if D7= D4 + (C6*D7)
Total copy - Download - File management
Total video converter for pc - Download - Video converters
Total war warhammer 3 free download - Download - Strategy
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide

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

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!

Similar discussions

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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!