Formula confusion

  • Thread starter Thread starter David B
  • Start date Start date
D

David B

Here is the formula that is giving me trouble, it's a
simple formula but it's not doing what I want it to do.
=IF(OR(ISBLANK(D14),D14<0),"",D14*E14
This formula is located in cell F14.
The D14<0 is the argument that is troubling me. What I
want to have happen is if D14 is a number such as 0.1,
0.01, etc. F14 should be blank. But what's happening is
the formula is looking for a negative number in D14.
How can I have the formula look for positive values less
than zero so that F14 returns a blank cell?

Thanks
 
First of all, 0.01 is not less than zero, maybe you meant less than 1?

=IF(OR(ISBLANK(D14),D14<1),"",D14*E14)

maybe less than 0.2

=IF(OR(ISBLANK(D14),D14<0.2),"",D14*E14)


--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
How can I have the formula look for positive values less
than zero
Click to expand...

I'm not aware of any positive values that would be less than zero. What do you
mean?


--ron
 
You're correct Peo, I mis-stated what I meant to say. I
figured out that I could add two arguments, D14<=0,D14<1,
and this gives me the needed results.

Thanks
 
Back
Top