Search: "nested IF"

#XLOOKUP #VLOOKUP #Excel formulas

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...

👁 18 views

#xlookup #excel formulas #index match

Excel XLOOKUP Multi-Criteria Lookup Replacing INDEX-MATCH

Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...

👁 17 views

#design #design-system #tokens

Excel XLOOKUP Formula for Multi-Criteria Search

Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...

#excel #xlookup #formula

👁 16 views

coding Advanced

ChatGPT Prompt for Refactor Legacy API Handler Safely

I need help refactoring a legacy API handler without breaking behavior. Here is ...

#coding #refactor #api

👁 15 views

design Advanced

Design System Token Naming Convention for Multi-Brand Theming

Propose a design token naming convention that supports multi-brand theming (we h...

👁 15 views

#expense report #auto-categorization #budget tracking

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. In...

👁 13 views

education Beginner

Concept Map Builder for Difficult Topic

Act as a learning coach. Help me build a concept map for [TOPIC]. Produce: (1) t...

#concept-map #study #visualization

👁 13 views

productivity Intermediate

ChatGPT Prompt: Inbox Zero Triage System for High-Volume Email

You are a productivity systems designer. Build me an inbox triage system that sc...

#productivity #inbox-zero #email

👁 12 views

#excel #inventory #reorder-point

Excel Inventory Reorder Alert with Lead Time and Safety Stock

Build an Excel reorder-alert sheet for a small warehouse. Inputs (one row per SK...

👁 12 views

#excel #formulas #xlookup

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

👁 12 views

#excel #let-function #formulas

Replace nested IFs with a clean LET formula that future-you can read

You are an Excel formula refactorer. Here is a nested IF formula that works but ...

👁 9 views

Excel: Replace a Wall of Nested IFs With One Clean SWITCH or IFS

I have a nested IF formula that's grown unmaintainable. Rewrite it using SWITCH,...

#excel #formulas #switch

👁 8 views

#excel #formulas #debugging

Reverse-engineer a broken Excel formula someone else wrote

I inherited a spreadsheet with a long, nested Excel formula I don't understand a...

👁 7 views

#LET function #nested IF #refactor

Replace a fragile nested IF with a clean LET-based formula

Here is a nested IF that has grown to 7 branches and is breaking when someone ad...

👁 6 views

#excel #formulas #commission

Build a Nested IF Formula for Tiered Commission

You are an expert Excel formula engineer. Help me write and explain a single Exc...

👁 5 views

#excel #formulas #xlookup

Write a nested IF that a coworker can actually read

I need an Excel formula that assigns a grade band based on a score, with at leas...

Write Nested IF and IFS Formulas for Tiered Commission

Act as an Excel formula expert. I need to calculate sales commission using tiere...

#excel #formulas #ifs

#excel #formulas #dynamic-arrays

Build a Dynamic Array Dashboard Formula

You are an Excel power user. I will describe a dataset and a reporting goal, and...

data Intermediate

Write and Explain a SQL Query From Plain English

Act as a SQL expert. I will describe what I want in plain English and you will w...

#data #sql #databases