Excel Status Calculation Based On Column Comparison
ASecurity
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.
Installs into .claude/skills of the current project.
Are you the author of Excel Status Calculation Based On Column Comparison?
Add the live security badge to your README. It updates with every re-scan.
[](https://www.skillsdirectory.com/skills/ecnu-icalk-excel-status-calculation-based-on-column-compariso)
---
id: "a98ff4de-0275-4459-a9b3-4108b849ef7d"
name: "Excel Status Calculation based on Column Comparison"
description: "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."
version: "0.1.0"
tags:
- "excel"
- "formula"
- "nested if"
- "status calculation"
- "comparison"
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"
---
# 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
