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

"The Hun" wrote in message ...
| 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,
|
|

On Mar 30, 3:02 pm, "Niek Otten" wrote:
<(that's point seventy-five, less than zero)

.75 isn't less than zero

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"The Hun" wrote in ...

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

Don't worry, this happens to all of us, every now and then!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"The Hun" wrote in message ...
| On Mar 30, 3:02 pm, "Niek Otten" wrote:
| <(that's point seventy-five, less than zero)
|
| .75 isn't less than zero
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "The Hun" wrote in ...
|
| | 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.