ExcelBanter - excel formual needed

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - excel formual needed (https://www.excelbanter.com/excel-discussion-misc-queries/79626-excel-formual-needed.html)

WYN

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

davesexcel

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

All times are GMT +1. The time now is 08:29 PM.