conditional formulas
=if(I12N12,N12-D12,I12-D12)
I assume you put J12 there because that is where you put this formula
--
Regards,
Peo Sjoblom
"Danno" wrote in message
...
Thanks, but that just returns "FALSE" and doesn't do the calculations.
"JasonP CCTM LV" wrote:
=if(I12N12,J12=(N12-D12),J12=(I12-D12))
"Danno" wrote:
Anyone know how to write a formula for this?
IF(I12N12) then J12=(N12-D12) but if(I12<N12) then J12=(I12-D12)
where I12 is derived from another formula (=SUMC12+M12) and C12, M12
and N12
are simply input numbers.
|