How to place and X in cell F7

[Closed]
Report
Posts
3
Registration date
Thursday March 22, 2018
Status
Member
Last seen
April 6, 2018
-
 Blocked Profile -
Hello,
I am in excel, I want to be able to place and X in cell F7 and have the time automatically be placed in cell G7. can someon please help me.
Thanks
Bill

1 reply

So which part do you need help with?

If syntax is as follow:

=IF(logic_test,true,false)

So, we could do:
=IF(a1="x","IT IS TRUE")


Time syntax can be WAY SIMPLIFIED with:
TEXT(NOW(),"HH:MM:SS")


So, let us know if you need more help. Understand, the time will change every time the sheet is recalculated!