positive value and importing data

[flashing frank]

hi,
i am very new in excel, and i have a questions

i am working with very simple functions, and now i want to add
function that only shows positive values after calculating.
i.e. 5-2=3
but
0-2=0

i hope someone can help me with that problem

greetz
f

 

[JE McGimpsey]

One way:

A1: 5
A2: 2
A3: =MAX(A2-A1, 0)

 

[Sandy Mann]

With you data in A1 & B1 try

=MAX(A1-B1,0)

HTH

Sandt

 

[Dave Peterson]

One way is to check it:

=if(yourformula<0,0,yourformula)

Another way is to just limit the lower value with =Max()

=max(0,yourformula)

If your formula evaluates to -2, then 0 is bigger and will be used.

If your formula evaluates to 326, then that's bigger than 0 and will be used.