convert negative numbers to zero

[Frank]

I'm doing a very basic spread sheet with stocks and stock
options, trying to get the Total value by entering
(eventually) only the stock price. Thus, most of them
are number of shares multipied by the current stock
price, and sum each category. The options are easy if
the current stock price is above the exercise price,
because then it has a positive value when you subtract
exercise from current price and multiply the result by
number of shares concerned. However, if the current
price is equal to or less than the exercise price, the
value must come up as $0. How do I change a negative
value in =(B4-31)*1000 to $0? (B4 is current stock
price; 31 is the exercise price; 1000 is the number of
shares). Thanks for any help for a rookie.

 

[Peo Sjoblom]

One way

=MAX((B4-31)*1000,0)

 

[Harald Staff]

Instead of
=(B4-31)*1000
use
=MAX(0,(B4-31)*1000 )
perhaps ?