View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
The Hun The Hun is offline
external usenet poster
 
Posts: 14
Default IF_THEN_ELSE question

Here's what I have:

A1 = .75 (that's point seventy-five, less than zero)
B1 = the argument =IF(A1<0,A1,0)

The result I get in B1 is 0 when it should get the number in A! which
is .75 (point seventy-five).
If A1 is 3 (or any number greater than zero), I get whatever the
number in A1 is, but I should get 0..

If I change the argument to 0 (greater than zero), it always gives me
the number in A1, even when it's less than 0.

Yes, I triple-checked all the numbers I put in A1 to make sure there
were no misplaced decimals.

Can someine tell me where I'm going wrong?

Thanks,