Need an If:Then statement help

  • Thread starter Thread starter RGT
  • Start date Start date
R

RGT

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Want to change the color of a true/false logical statement with i. 2
If Then help needed 2
Combining IF Statement and Vlookup 0
VB Code is working for row1; how to apply to row2? 5
Displaying zeros in cells 2
Need Help with an Excel Formula! 9
How to enter formula to give warnings 2
IF Function with multiple text entries 6

Back
Top