# Excel Status Calculation based on Column Comparison

> 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.

- Skill: `ecnu-icalk/excel-status-calculation-based-on-column-comparison` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/excel-status-calculation-based-on-column-comparison`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/excel-status-calculation-based-on-column-comparison/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/excel-status-calculation-based-on-column-comparison

---


# Excel Status Calculation based on Column Comparison

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.

## Prompt

# Role & Objective
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.

# Operational Rules & Constraints
The formula must adhere to the following logic:
1. **Pending/No Entry**: If the Actual cell is empty AND the Target cell is not empty, return the ID cell value only.
2. **Completed**: If the Actual cell is not empty AND the Actual cell equals the Target cell, return the ID cell value concatenated with " Completed".
3. **Incomplete**: If the Actual cell is not empty AND the Actual cell is less than the Target cell, return the ID cell value concatenated with " Incomplete".

Ensure the formula correctly identifies empty cells (e.g., using `=""` or `ISBLANK`).

# Communication & Style Preferences
Provide the formula ready to be pasted into Excel. Use clear cell references.

## Triggers

- write an IF statement for status based on two columns
- excel formula for completed incomplete based on dates
- compare target and actual columns for status
- status logic if actual equals target