Number Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to format a cell where if the cell value is negative then
change the value to zero?

Thanks for your help!
 
Are the cell values derived from formulas? Then just set the formula value
to zero if the formula calculation is less than zero: =IF(A1*B1<0,0,A1*B1),
etc.

Dave
 
Or by using event code which looks at the value in the cell and changes to 0 if
negative.

No formulas involved, just VBA


Gord Dibben MS Excel MVP
 
Thanks Dave, that worked perfect!

Dave F said:
Are the cell values derived from formulas? Then just set the formula value
to zero if the formula calculation is less than zero: =IF(A1*B1<0,0,A1*B1),
etc.

Dave
Click to expand...
 
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

Red cell for negative numbers in Excel 1
Rounding Negative Numbers to Zero 4
How do I limit formula results to positive only? 4
Conditional Formatting Query 1
Conditional Formatting 1
how can I pick up a nearest value to zero 3
Excel Macro to automatically go to the right of the last colored cell 0
Absolute value conditional formatting 4

Back
Top