| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formual needed
good day all,i need a formula to do the following.=if(q80=closed,q1=now())
i want q1 to show the date by entering the word closed in cell q80? any help is appreciated. -- wynb |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel formual needed
=IF(Q80="closed",NOW(),"") place this formula in Q1 format the cell for date -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=526513 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel Developer Needed - Dallas, TX | Excel Discussion (Misc queries) | |||
| Excel VBA debugging help needed! | Excel Discussion (Misc queries) | |||
| Excel networking help needed for backup | Setting up and Configuration of Excel | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Linear Mode
