If stmt and assigning a value to another cell

L

lovethepirk

Much love for any help :)

I have this if statment:

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?

Thanks,

LTP
 
M

Max

lovethepirk said:
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?
Click to expand...

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
 
Top