Formula condition!!

[Bob Vance]

--

=SUM(DG164G165)
Only calulate if only if (DJ168>0) is more than zero

Thanks in advance for your help....Bob Vance

 

[Harald Staff]

Hi Bob

=SUM(DG164G165)*(DJ168>0)

 

[Dave R.]

just place that condition with an IF before the other one;

IF(DJ168>0,SUM(DG164G165),"FALSE")

 

[Bob Vance]

Thanx