#1
|
|||
|
|||
IF Formula - multiple values
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, |
#2
|
||||
|
||||
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
using if and compare with multiple criteria and ranges of values | bill3kradio | Mail Merge | 7 | 11-17-2014 01:06 PM |
I need to add multiple values based on multiple criteria in a cell not sure what to do | AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |
VLookup multiple values and Sum | tinfanide | Excel | 2 | 09-02-2014 11:41 AM |
Excel - search Multiple Values (HELP!) | duskdjl | Excel | 4 | 03-28-2013 01:11 AM |
Breaking Links In A Formula And Making Them Values, Office 2003 | tcohen | Excel | 1 | 03-18-2013 07:05 AM |