"lovethepirk" wrote:
if((A1+B1)0,A1+B1,C1=100)
If A1 + B1 is less than zero I want to make cell C1=100
and for it to appear on the screen. Is there a way to accomplish this?

Put in C1: =IF(SUM(A1:B1)0,SUM(A1:B1),100)
Note that a formula can only evaluate/return values in it's own cell
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---