Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |