positive value and importing data

  • Thread starter Thread starter flashing frank
  • Start date Start date
F

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
 
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.
 
Back
Top