| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell "A" Adds data to Other Cells
I entered the code into Cell C2 then Pressed Enter. Now it pops up a message saying ERROR- "The Formula you type contains an error" This was the Code i entered into Cell C- =IF(A2=1;"YES";IF(A2=2;"NO";IF(A2=3;"YES";IF(A2=4; "NO";"")))) I dont care about the YES NO things at the moment. I would be happy if it worked. You have been alot of help and i thank you so much, if its not to much of a problem, could you try this and see if it works, its not working for me at all. -- joelbeveridge ------------------------------------------------------------------------ joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045 View this thread: http://www.excelforum.com/showthread...hreadid=567717 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
