| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
When I use the function arguments it says if(ID606="Y" is true when ID606 is
blank .WHY? =IF(ID606="Y",1,2) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Question
there must be something in your cell ID606 then...i just checked and i get
false and 2 for answers... "oldjay" wrote: When I use the function arguments it says if(ID606="Y" is true when ID606 is blank .WHY? =IF(ID606="Y",1,2) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Question
I put a new formula =if(C1="Y",1.2) in A!. I get the same result. I even
deleted C1 just to be sure there was nothing in it. Now I added a new sheet to this same workbook, put in the same formula and and got the correct answers. What could be possible wrong with the original sheet to yield this result? "walrus" wrote: there must be something in your cell ID606 then...i just checked and i get false and 2 for answers... "oldjay" wrote: When I use the function arguments it says if(ID606="Y" is true when ID606 is blank .WHY? =IF(ID606="Y",1,2) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Question
"oldjay" wrote:
When I use the function arguments it says if(ID606="Y" is true when ID606 is blank .WHY? =IF(ID606="Y",1,2) The only thing that comes to mind is that you have format or conditional format options that are selecting the same color for foreground and background. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Newbie Formula Question - how to get formula to repeat in each subsequent row? | New Users to Excel | |||
| Formula question | Excel Worksheet Functions | |||
| Formula Question | Excel Discussion (Misc queries) | |||
| Formula Question | Excel Worksheet Functions | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Linear Mode
