IF and OR Functions

[MrDB4Excel]

I have a simple date and checkmark setup that is having problems.
Prior to trying the ‘if’ and ‘or’ in the same formula I only was using if.
Then I noticed I needed to apply a separate date depending on if something was done the day before or if it was being done on the current date.
As you can see in cells E14 thru to G15 are new formulas of this type: =IF(OR($F14=$F$2,$F14=$G$2),$F$1,$G$1)
whereas below row 15, they are of this type: =IF($F16=$F$2,$F$1,"")

What am I doing wrong here? If a cell in column F is ck then the formulas would return the date in F12. If a cell in column F is dn then the formulas would return the date in F11.
Conversely, if a cell in column F is ck then in column E would be a single checkmark, and if dn then a double checkmark.
I hope this makes sense.
Any help is much appreciated.

RestoreActions.xlsx
	B	C	D	E	F	G	H
1		Macrium Backup Restore			ü	üü
2	#	Action	Additional Info		ck	dn
3	1	Roboform Before Restore	Insert any new data that was added after last Macrium Backup
4	2	Outlook Before Restore	Run Sync Back Free For Outlook
5	3	Outlook After Restore	Copy From E:\FromC-Outlook to >>> C:\Users\Dwight\AppData\Local\Microsoft\Outlook
6	4	Roboform After Restore	Add Back Into RoboForm Any New Data
7	5	Brave Browser History	Run BrowsingHistoryView.exe to get current date history, paste into appropriate sheet of the current month workbook. Delete Browser History, not including TODAY		27/10/2022	14:33:15
8	6	Roboform Data Backup Information	RoboForm PrintList Settings: 1 Column, 70% for Logins & Safenotes, 60% for Identities; Margins: .25 Left&Right, .35 Top&Bottom
9			Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\15.0\Excel\Options
10			How to Increase the Number of Jump List Items in Windows 10
11		PureText.exe	H:\Downloads\Downloads2\PureText\puretext_6.2_64-bit		27/10/2022
12		Pre Macrium Backup			28/10/2022	14:33:15
13		Action	Additional Info
14	1	Disk Cleanup	Windows 10 Update Wastes 20GB: How to Get It Back	ü	dn	28/10/2022
15	2	Run sfc /scannow	sfc-scannow-Images	ü	ck	27/10/2022
16	3	Belarc Advisor	Run Belarc to get Current System Status - Save to H:\Downloads\BelArc-Adviser\Belarc Advisor Reports
17	4	calibre 64bit - E-book manager	Check for calibre 64bit - E-book management new version
18	5	WiseCare	Run WiseCare: Prior to running WiseCare close all Excel Workbooks, Web Browser, Outlook etcetera so that the only program running is WiseCare
19	6	BrowsingHistoryView.exe	Run BrowsingHistoryView.exe to get current date history, paste into appropriate sheet of the current month workbook. Delete Browser History, not including TODAY
20	7	Sync Back Free	Run Sync Back Free: Excel Files, If Needed and Outlook
21			Copy current ost & pst files from C:\Users\Dwight\AppData\Local\Microsoft\Outlook via Sync Back Free
22	8	Agent Ransack	Run Agent Ransack to get all wbk files moved to M:\WordBackupDocs
23	9	RoboForm	Get any RoboForm data that needs entered here in Sheet RestoreActions2
24			Run the PrintList Option in RoboForm as PDF - Save to a Current Date Folder in H:\Downloads\Roboform\PrintLists
25			GoTo RoboForm Options > Account & Data > Export to Create a CSV file for Login Data; Save to Current Date Folder in H:\Downloads\Roboform\Exports
26	10	GoodSync	Run GoodSync Jobs But Do Not Run GoodSync for Macrium Backup from M Drive to N, O, & P Drives Until After Macrium Backup
27	11	Desktop	Using Snip & Sketch get current images of desktop
28	12	Brave Extensions	Get Image of Brave Extensions
29	13	Windows OS Updates	Check Window's Updates Per 3rd to 4th Week and How That Date Coordinates With the Next Macrium Backup; The Next Window's Updates are Scheduled for: November 24, 2022	ü	ck	24/11/2022
30	14	Macrium Reflect	Run Macrium Reflect Backup: Change Advanced Options Per: Check Box for Auto Verify Image & Uncheck Box for BackupSet File Name Prefix; Format Rescue Disk & Run a New Build on the Rescue Disk				24/11/2022
31	15	GoodSync	Run GoodSync for Macrium Backup from M Drive to N, O, & P Drives				24/11/2022
32		Post Macrium Backup
33	1	Microsoft Office	REPAIR Microsoft Office - This Requires All Micosoft Office Programs To Be Closed	ü	ck	28/10/2022
34
35
36					November 24, 2022
MacriumSimpleSteps

Cell Formulas
Range	Formula
F7	F7	=TODAY()
G7,G12	G7	=NOW()
D8	D8	=MacriumBackupActions!B10
D16	D16	=MacriumBackupActions!B12
D20	D20	=MacriumBackupActions!$B$4
D21,D25	D21	=MacriumBackupActions!B7
D22:D23	D22	=MacriumBackupActions!B5
D24	D24	=MacriumBackupActions!B9
D26	D26	="Run GoodSync Jobs But Do Not "&D31&" Until After Macrium Backup"
D27	D27	=MacriumBackupActions!B8
D29	D29	="Check Window's Updates Per 3rd to 4th Week and How That Date Coordinates With the Next Macrium Backup; The Next Window's Updates are Scheduled for: "&$F$36
E14:E15	E14	=IF(OR($F14=$F$2,$F14=$G$2),$F$1,$G$1)
E26:E33,E22:E23,E16:E20	E16	=IF($F16=$F$2,$F$1,"")
D33	D33	=MacriumBackupActions!B25
G14	G14	=IF(AND($F14=$F$2,$F14=$G$2),$F$11,$F$12)
G15	G15	=IF(OR($F15=$F$2,$F15=$G$2),$F$11,$F$12)
G30:G33,G26:G28,G22:G23,G16:G20	G16	=IF($F16=$F$2,$F$12,"")
G29	G29	=IF($F29=$F$2,$H$30,"")
F36	F36	=TEXT($H$31,"mmmm dd, yyyy")

 

[StephenCrump]

Are ck and dn the only two possible options?

If so, I think you're looking for:

E14: =IF(F14=F$2,F$1,G$1)
F14: =IF(F14=F$2,F$12,F$11)

 

[MrDB4Excel]

Well, it kind of works. Still some bugs to work out. Essentially when "ck" is entered into any row (from row 14 down to row 33) of column "F" then the corresponding row cell in column "E" will insert only one checkmark and in addition, the corresponding row cell in column"G" will insert the date shown in cell F12.
Conversely when "dn" is entered into any row (from row 14 down to row 33) of column "F" then the corresponding row cell in column "E" will insert two checkmarks and in addition, the corresponding row cell in column"G" will insert the date shown in cell F11.
I did make a slight alteration as you will see here below.
So your formulas seem to be missing something, not sure what so I will provide here an Xl2bb Mini Sheet:
As you can see, cells F17, F18, & F19 are empty yet the corresponding row cells in columns E & G get filled in with data.

RestoreActions.xlsx
	E	F	G
1		ü	üü
2		ck	dn
3
4
5
6
7		28/10/2022	01:47:09
8
9
10
11		27/10/2022
12		28/10/2022	01:47:09
13
14	üü	dn	27/10/2022
15	ü	ck	28/10/2022
16	üü	dn	27/10/2022
17	üü		27/10/2022
18	üü		27/10/2022
19	üü		27/10/2022
20
21
22
23
24
25
26
27
28
29	ü	ck	24/11/2022
30
31
32
33	ü	ck	28/10/2022
MacriumSimpleSteps

Cell Formulas
Range	Formula
F7	F7	=TODAY()
G7,G12	G7	=NOW()
E14:E19	E14	=IF(F14=F$2,F$1,G$1)
E20,E26:E33,E22:E23	E20	=IF($F20=$F$2,$F$1,"")
G14:G19	G14	=IF(F14=F$2,F$12,F$11)
G20,G30:G33,G26:G28,G22:G23	G20	=IF($F20=$F$2,$F$12,"")
G29	G29	=IF($F29=$F$2,$H$30,"")

 

[StephenCrump]

You've referred to your formula and your new formula, and asked what you were doing wrong, but you haven't stated clearly what results you'd like to see.

So, again, a guess. Are you looking for?

E14: =IF(F14=F$2,F$1,IF(F14=G$2,G$1,""))
G14: =IF(F14=F$2,F$12,IF(F14=G$2,F$11,""))

 

[MrDB4Excel]

Awesome StephenCrump, you did it. This works exactly as I intended.
Thank you so much. Before posting I fought with this thing for far too long. I was putting too much emphasis on the =if(or( kind of formula.

 

[StephenCrump]

No problem. I'm glad we could help.