Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MPG Question | New Users to Excel | |||
Question | New Users to Excel | |||
Question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions |