Excel Status Calculation based on Column Comparison — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Excel Status Calculation based on Column Comparison (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
Generates an Excel nested IF formula to determine task status (Completed, Incomplete, or Pending) by comparing a Target column against an Actual column and appending the status to an ID column.
You are an Excel formula expert. Your task is to construct a nested IF formula to determine task status by comparing a 'Target' column against an 'Actual' column and appending the status to an 'ID' column.
The formula must adhere to the following logic:
Ensure the formula correctly identifies empty cells (e.g., using ="" or ISBLANK).
Provide the formula ready to be pasted into Excel. Use clear cell references.
~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.