All solutions IF Expert Solution – Excel IF Problems

Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Do I have to pay for a solution ? I just wasted time with another help desk that asked for $46 for an answer. If that is the case, thanks anyway.
Solved by X. U. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 27/03/2018 - 06:31
Hi there
User 27/03/2018 - 06:34
I am trying to change the dates in a column to show: today's date and current time. This info should be static and the cell. l should populate as I tab over it. HELP
Excelchat Expert 27/03/2018 - 06:35
I really apologize regarding the payment that was asked to you, we are investigating on that
Excelchat Expert 27/03/2018 - 06:36
Sure, i will help you with this issue in excel
User 27/03/2018 - 06:36
It was not your website. It was another website. I am just looking for free online help. Can you help ?
Excelchat Expert 27/03/2018 - 06:37
Yes i will surely help you
Excelchat Expert 27/03/2018 - 06:37
Can you share me a sample worksheet
Excelchat Expert 27/03/2018 - 06:37
So that we both can have a better evaluation to the issue
User 27/03/2018 - 06:37
I cannot. It is proprietary to the company.
Excelchat Expert 27/03/2018 - 06:38
okay will give you the for formula for todays date and time in excel, will that be good
User 27/03/2018 - 06:38
OK
Excelchat Expert 27/03/2018 - 06:38
So the formula is =NOW()
User 27/03/2018 - 06:39
The bracket is for ??
Excelchat Expert 27/03/2018 - 06:39
just copy it to any of the cell and you will get todays Date and time
User 27/03/2018 - 06:39
Will it stay static (unchanging from day to day) ??
Excelchat Expert 27/03/2018 - 06:39
yes the whole thing you have to copy =NOW()
User 27/03/2018 - 06:40
Thank you sooooooo much - you have saved me a lot of time. I will put you in speed dial for the future.
Excelchat Expert 27/03/2018 - 06:41
well after getting the date and time you can paste it as values to make it static
User 27/03/2018 - 06:41
How do I do that ?
Excelchat Expert 27/03/2018 - 06:41
Okay,
Excelchat Expert 27/03/2018 - 06:42
so to do that
Excelchat Expert 27/03/2018 - 06:43
just copy the date and time by pressing ctrl+C
Excelchat Expert 27/03/2018 - 06:43
and then press Alt + E+S+V
Excelchat Expert 27/03/2018 - 06:43
simultaneously One by one
User 27/03/2018 - 06:44
And this will allow me to tab over the cell and the current info will populate the cell ?
Excelchat Expert 27/03/2018 - 06:45
yes it can be redone
Excelchat Expert 27/03/2018 - 06:45
just paste the formula again there
User 27/03/2018 - 06:46
OK - I will try it. If I get in trouble, how do I fix it ?
Excelchat Expert 27/03/2018 - 06:46
there wont be any major trouble, with this formula
User 27/03/2018 - 06:47
I love your confidence - thanks again !! Signing off.
Excelchat Expert 27/03/2018 - 06:47
so dont worry, this is the best formula i have shared with you
Excelchat Expert 27/03/2018 - 06:47
Please do a valuable rating for me
Excelchat Expert 27/03/2018 - 06:47
that will help me a lot
User 27/03/2018 - 06:47
where is that ?
Excelchat Expert 27/03/2018 - 06:47
:)
Excelchat Expert 27/03/2018 - 06:47
you will get the options when you exit the session
Excelchat Expert 27/03/2018 - 06:48
Thanks for being in Got it Pro!
Excelchat Expert 27/03/2018 - 06:48
Have a nice day!
Excelchat Expert 27/03/2018 - 06:48
After pressing the end session button, you will get the options :)
Excelchat Expert 27/03/2018 - 06:49
If you really liked it then please put some good words for me :)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc