IF Statement with Two Conditions

[dmpope]

Hi there,

I'm trying to get this IF statement to work in the formula tool, basically what I'm looking for is to create a new column based on a department number where it'll calculate a figure based on if one column contains "CUSTOMER" and another column also contains the department number on the same record/line. I'm sure it's something to do with my syntax since it's failing once I type ELSE, but I can't figure it out. Any help is appreciated!

[alexnajm]

My guess would be that one of your columns Story Points, Active Minutes, Sum_Capex Points by Team, or Sum_Capex Actual, is not being stored as a number! Can you check that first?

[alexnajm]

I would also check that Peoplesoft Department is being currently stored as a number and not a string!

[alexnajm · Accepted solution]

You are also missing an ending parentheses right before ELSE

[dmpope]

Thanks Alex! I knew it had to be a simple fix, now time to get some more caffeine 😅

[alexnajm]

Happens to the best of us! 😊