If stmt and assigning a value to another cell
 

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


--
lovethepirk
------------------------------------------------------------------------
lovethepirk's Profile: http://www.excelforum.com/member.php...o&userid=33391
View this thread: http://www.excelforum.com/showthread...hreadid=532156

If stmt and assigning a value to another cell
 

"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
---

If stmt and assigning a value to another cell
 

Thanks :) I am not sure what I was thinking that was a simple answer
:)

LTP


--
lovethepirk
------------------------------------------------------------------------
lovethepirk's Profile: http://www.excelforum.com/member.php...o&userid=33391
View this thread: http://www.excelforum.com/showthread...hreadid=532156

If stmt and assigning a value to another cell
 

"lovethepirk" wrote:
Thanks :) I am not sure what I was thinking
that was a simple answer
:)

You're welcome !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---