Stuck on a formula

[Kasaia]

Hello.

I am attempting to write a formula that will take the sum
of two cells (=sum(D12-C12)and if that number is greater
than 628 I want the calculation to show up on F12. I
thought the sumif would work for me but it hasn't. I also
tried to do it another way, having the calculation's from
cells D12-C12 report to cell E12 and then my formula would
just be that if E12 is greater than 628 then I wanted it
to show up in cell F12. Confusing? Any feedback that I
could get on this would be very helpful.

Thanks,
Kasaia

 

[Frank Kabel]

Hi
try
=IF(SUM(C1212)>628,SUM(C1212),"")

 

[Bob Phillips]

=IF(SUM(C12,D12)>628,SUM(C12,D12),"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)