How to place and X in cell F7

Closed
BWitham5 Posts 3 Registration date Thursday 22 March 2018 Status Member Last seen 6 April 2018 - 22 Mar 2018 à 13:02
 Blocked Profile - 22 Mar 2018 à 14:39
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
Related:

1 response

Blocked Profile
22 Mar 2018 à 14:39
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!