Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

IF_THEN_ELSE question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
The Hun - 30 Mar 2008 23:48 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.