IF Formula - multiple values

Jac_Fcb

Jac_Fcb

New member
Joined
Mar 16, 2015
Messages
2
Reaction score
0
Points
0
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,
 
maybe something like....

=LOOKUP(D4,{"Complete","In Process","Pending"},{1,0,-1})
 
Try below formula
=IF(D4="COMPLETE",1,IF(D4="IN PROCESS",0,IF(D4="PENDING",-1,"")))
 
You must log in or register to reply here.
Back
Top