View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lovethepirk
 
Posts: n/a
Default 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