1187 Views
6 Replies
Latest reply:
Mar 15, 2010 10:03 AM by
Peggy

dbrandt6 Mar 15, 2010 4:17 AM
Re: I would like some help on the formulas to calculate the percentage of net.. in response to dbrandt6in both cases of "both boxes checked" or "both boxes UNchecked", that the assigned profit percentage just be split between "D" and "M" evenly. The 'financial' result would be the same with fewer formulas.
Just a thought. 
Badunit Mar 15, 2010 8:19 AM
Re: I would like some help on the formulas to calculate the percentage of net.. in response to dbrandt6In answer to your first question here is one possible formula:
G2=IF(B2,E2/COUNTIF(B2:C2,TRUE),0)
H2=IF(C2,E2/COUNTIF(B2:C2,TRUE),0) 
dbrandt6 Mar 15, 2010 8:31 AM
Re: I would like some help on the formulas to calculate the percentage of net.. in response to Badunitsome of the tasks may not be necessary on each job. ie... no subcontractors needed. If neither "D" or "M" are checked on the same row, can the result in the G and H column also read 1.8%? 
Badunit Mar 15, 2010 8:45 AM
Re: I would like some help on the formulas to calculate the percentage of net.. in response to dbrandt6G2=IF(B2,IF(C2,E2/2,E2),IF(C2,0,E2/2))
H2=IF(C2,IF(B2,E2/2,E2),IF(B2,0,E2/2)) 
dbrandt6 Mar 15, 2010 8:52 AM
Re: I would like some help on the formulas to calculate the percentage of net.. in response to BadunitGreatly appreciated! 
Peggy Mar 15, 2010 10:03 AM
Re: I would like some help on the formulas to calculate the percentage of net.. in response to dbrandt6Should you need to post a screenshot again, here's a thread in Feedback about Discussions with the information you need.