← Back to Home / Excel

Excel Complex Nested IF

Writes complex Excel formulas easily.

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