PromptVault
Home
Prompts
SEO
Coding
Blog
← Back to Home
/
Excel
Excel Complex Nested IF
Writes complex Excel formulas easily.
Copy Prompt
Write an Excel formula using nested IFs and VLOOKUP. If cell A2 is greater than 100, look up the value in range D2:F10 and multiply by 1.5. If not, return "Low Stock".