not less that zero

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phillip Devoll - 23 Oct 2004 07:44 GMT

what do I do so a will get "0" if the answer is less than zero such as 5 -
6 and it give me "0"

Reply to this Message

VENKAT - 23 Oct 2004 07:54 GMT

your reequiremnt is not clear. however use tis formula in any cell
suppose a1 is 5,a2 is 6
type this in any other cell
=IF(A1-A2<0,0,A1-A2)
=======================

> what do I do so a will get "0" if the answer is less than zero such as
> 5 -
> 6 and it give me "0"

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Reply to this Message

Frank Kabel - 23 Oct 2004 07:58 GMT

Hi
=MAX(your_formula,0)

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> what do I do so a will get "0" if the answer is less than zero such as 5 -
> 6 and it give me "0"

Reply to this Message