IF_THEN_ELSE question

  • Thread starter Thread starter The Hun
  • Start date Start date
T

The Hun

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,
 
<(that's point seventy-five, less than zero)>

..75 isn't less than zero

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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,
|
|
 
<(that's point seventy-five, less than zero)>

.75 isn't less than zero

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| 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,
|
|
Click to expand...


Hahahahaha.... Oops!.... What on earth was I thinking. Obviously, I
wasn't. I hate to even admit how many intricate spreadsheets I've
constructed with several cells strung together with each one max'd out
with 7 nested If-Then_Else arguments. I need to go back on the meds.
--- Thanks.
 
Don't worry, this happens to all of us, every now and then!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| > <(that's point seventy-five, less than zero)>
| >
| > .75 isn't less than zero
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| >
| > | 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,
| > |
| > |
|
|
| Hahahahaha.... Oops!.... What on earth was I thinking. Obviously, I
| wasn't. I hate to even admit how many intricate spreadsheets I've
| constructed with several cells strung together with each one max'd out
| with 7 nested If-Then_Else arguments. I need to go back on the meds.
| --- Thanks.
 
Back
Top