ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Need an If:Then statement help (https://www.excelbanter.com/new-users-excel/14156-need-if-then-statement-help.html)

RGT

Need an If:Then statement help
 
I need to create some kind of If:Then statement in an excell page.

Basically, it needs to be that if the value is less than zero it shows
zero, else show the value.

any suggestions??

Russell

CLR

Assuming your value of interest is in cell A1, put this formula where you
wish the result.........

=MAX(0,A1)

Vaya con Dios
Chuck, CABGx3


"RGT" wrote in message
...
I need to create some kind of If:Then statement in an excell page.

Basically, it needs to be that if the value is less than zero it shows
zero, else show the value.

any suggestions??

Russell





All times are GMT +1. The time now is 10:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com