Need help with a "IF Then" formula

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

RGT

I need a if/then statement that will basically show the following



if sum is less than zero then sum=0
else show sum.


Thanks,
Russ
 
=MAX(0,SUM(A1:A10))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

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

How to set cell value to emptry if three other columns are empty too 1
If/Then help needed 2
Excel formula, sum the value cell and if empty cell left blank 0
SUM / COUNT formula 3
Trouble flagging conditions in Excel using VB 6
Help with formula 3
sum 1
Offset, Match Questiond 5

Back
Top