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
Blocked Profile - Mar 22, 2018 at 02:39 PM
Related:
- How to place and X in cell F7
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Conditional formatting if cell contains text - Excel Forum
- Which key is used to make multiple line in a single cell - Guide
1 response
So which part do you need help with?
If syntax is as follow:
So, we could do:
Time syntax can be WAY SIMPLIFIED with:
So, let us know if you need more help. Understand, the time will change every time the sheet is recalculated!
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!