ExcelBanter - Help with IF

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help with IF (https://www.excelbanter.com/excel-worksheet-functions/85797-help-if.html)

zuketrax

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

JMB

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

All times are GMT +1. The time now is 07:28 AM.