LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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,


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MPG Question ClarkDis New Users to Excel 7 August 31st 07 09:18 PM
Question John Calder New Users to Excel 1 November 24th 06 09:00 AM
Question dk Excel Discussion (Misc queries) 1 July 7th 06 06:08 PM
Newbie Question - Subtraction Formula Question [email protected] Excel Discussion (Misc queries) 3 May 5th 06 05:50 PM
The question is an excel question that I need to figure out howto do in excel. Terry Excel Worksheet Functions 3 January 23rd 06 06:22 PM


All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"