| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF = text Show "NIL" ..?
Yes zero is the correct answer in this case. However you are asking the formular to put it in another cell (in this case we will say cell D1), I can only guess you are trying to say that for example the information is in C1 and the formular is in D1 and you are saying that if A1 = B1 then put that information in cell D1 if that is the case then yes zero is correct. The way that I normally would do it is =if(A1=B1,C1,if(A1=B1,D1,0)). I hope this is of help to you but please bare in mind I am only new to this bussines of helping other people I am normally asking other people for help. But I am only to happy help if I can. Paul Maynard Moscow -- paulrm906 ------------------------------------------------------------------------ paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776 View this thread: http://www.excelforum.com/showthread...hreadid=500994 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
| Userform password to show "xxxxxx" in the text box | Excel Discussion (Misc queries) | |||
| if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions | |||
| conditional formula to show "open" or "closed" | Excel Worksheet Functions | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Threaded Mode
