How in a Formula total, if less than 0 enter 0?

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

Guest

i am trying to create a spread sheet and need to determin
if the sum is less than 1, enter 0,
if the sum is 1 or more to enter actual total.
 
This is an Access newsgroup. If you are trying to write a spreadsheet, then
you should try an Excel newsgroup.
 
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

Aggregate Function Error 0
Excel Formula or equation 3
more or less than 0 or blank 3
How to sum totals in Excel if cells contain a formula? 1
use addition function 2
Access Query problem 1
Totaling An Aggregate Expression On A Report 4
Access 2003 2

Back
Top