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
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
=if(expression<0,0,expression)
or
max(expression,0)
not a professional, just trying to assist.....
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" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks