Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with IF
Sorry I am new to excel. The formula I need is to know how to put these two formulas together so that they work. =b1-b2 =if(b2<=0,0) Thanks for any help -- zuketrax ------------------------------------------------------------------------ zuketrax's Profile: http://www.excelforum.com/member.php...o&userid=33934 View this thread: http://www.excelforum.com/showthread...hreadid=537082 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with IF
How do you want them put together?
=B1 - MAX(B2, 0) Or =IF(B2<=0, 0, B1-B2) "zuketrax" wrote: Sorry I am new to excel. The formula I need is to know how to put these two formulas together so that they work. =b1-b2 =if(b2<=0,0) Thanks for any help -- zuketrax ------------------------------------------------------------------------ zuketrax's Profile: http://www.excelforum.com/member.php...o&userid=33934 View this thread: http://www.excelforum.com/showthread...hreadid=537082 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|