In progress

I'm adding the values from 3 cells using the formula =SUM(C61,C63,C64)
. The value in cell C63 is calculated by a formula =SUM(C62*0.4) which
can sometimes produce a minus figure. When the figure in C63 is a minus
number, I want it to show a 0, so that the minus number is not factored
in to the sum of cells C61,C63,C64. Hope that makes sense! Any
suggestions gratefully received!

Replace
=SUM(C61,C63,C64)
with
=SUM(C61,C63*(C630),C64)


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=546187