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,
Niek Otten - 31 Mar 2008 00:02 GMT
<(that's point seventy-five, less than zero)>
.75 isn't less than zero

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Here's what I have:
|
[quoted text clipped - 15 lines]
|
| Thanks,
The Hun - 31 Mar 2008 00:17 GMT
> <(that's point seventy-five, less than zero)>
>
[quoted text clipped - 25 lines]
> |
> | 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.
Niek Otten - 31 Mar 2008 00:25 GMT
Don't worry, this happens to all of us, every now and then!

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| > <(that's point seventy-five, less than zero)>
| >
[quoted text clipped - 31 lines]
| with 7 nested If-Then_Else arguments. I need to go back on the meds.
| --- Thanks.