How to place and X in cell F7

Closed
BWitham5 Posts 3 Registration date Thursday March 22, 2018 Status Member Last seen April 6, 2018 - Updated on Mar 22, 2018 at 04:21 PM
 Blocked Profile - Mar 22, 2018 at 02:39 PM
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 response

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!


0