excel formual needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=IF(Q80="closed",NOW(),"")
place this formula in Q1
format the cell for date
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

= if formula needed 5
Snapshot function, 2003 to 2007 2
Average multiple colums 5
Formula IF 1
excels formuals 1
Sumproduct formula 3
How to distribute/spread/map cost of project across different year 3
3 out of 5? 5

Back
Top