View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default Displaying a Zero where the formula result would be negative

She meant "Some" as in "Some of my equations" :0

"Rick Rothstein (MVP - VB)" wrote:

Similar to the discussion thread in January, I am trying to figure out
how to
display a $0 where the sum of my equation would result in a negative
number.

For example, my formula is =m2*25

How would I create a formula that would automatically display $0 if the
sum
of the equation above resulted in a negative number?


=IF(M2<0,0,M2*25)


Another possibility...

=MAX(0,M2*25)

hmm.. what's this about a "sum"?


I wondered about that too.

Rick