Hello everyone!

I'm trying to come up with a formula that allows me to come up with a certain value (number) if the value next to it (text) is typed in.

e.g: IF D4 is equal to "Complete", then return "1". IF D4 is equal to "In process", return "0". IF D4 is equal to "Pending", return "-1"

Thanks in advance,