cell calculation check if result is negative and zero out if not l
Formula in cell =(B5-A5) I want to check if result is negative and if so
replace result with 0 So this cell will either be a positive number or zero. |
cell calculation check if result is negative and zero out if not l
=MAX(0,(B5-A5))
Vaya con Dios, Chuck, CABGx3 "Rich" wrote: Formula in cell =(B5-A5) I want to check if result is negative and if so replace result with 0 So this cell will either be a positive number or zero. |
cell calculation check if result is negative and zero out if not l
=MAX(B5-A5,0)
-- HTH RP "Rich" wrote in message ... Formula in cell =(B5-A5) I want to check if result is negative and if so replace result with 0 So this cell will either be a positive number or zero. |
All times are GMT +1. The time now is 09:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com