Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|