Forum Discussion

Edins425's avatar
Edins425
Copper Contributor
May 09, 2023
Solved

I can't get an IF formula with multiple conditions in column C provide 3 categories (one blank)

Hi, I'm trying to create 2 categories via a formula in column C (technically 3 with one being blank) "Labor", "Non-labor" and blank if neither based on the account. Essentially I think it's an IF/AND...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
May 09, 2023

Edins425 

In C2:

=IF(B2="Revenue", "", IF(AND(A2>="509510", A2<="520350"), "Labor", Non-labor"))

Fill down.

  • Edins425's avatar
    Edins425
    Copper Contributor
    May 09, 2023

    Thanks HansVogelaar, this worked great.

Resources