Thread: Help with IF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB
 
Posts: n/a
Default 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