|
|
#1
03-16-2015, 04:08 PM
|
|||
|
|||
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, 
|
|
|
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 |
Windows 8 
Office 2013
Threaded Mode