Forum Discussion
Solved
Problems with finding the right IF formula
Hi, I am trying to get a formula that can give 3 results/returns (Resolved, Pending and blank). There is a Status column where the answer returns and 2 other columns where I compare data to see if th...
RebekahR1415 One possibility could be:
=IF(AND(LEN(H2:I2)), "Resolved", IF(OR(LEN(H2:I2)), "Pending", ""))
Hi, it's giving 0 as the response. Not sure what I did wrong.
RebekahR1415 Copy the formula I used, then paste it into the formula bar with cell G2 selected.
If you're typing it out manually, make sure all of the brackets and commas are in the correct spot.
- It worked! Thank you