#1
|
|||
|
|||
Excel Formula for Multiple Conditions & Results
Hi, I need some help on Excel formula that I'm currently working on. The formula is working except for the 1st line (attached). Correct coding/result is "patient-janitorial", but current formula comes back as "patient". I don't know what to add or change the formula to give me the correct result. Thank you for your help!
|
#2
|
||||
|
||||
Your formula is rather complicated.
However, I don't see any string like "patient-janitorial" in it, so it cannot be returned
__________________
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 |
#3
|
|||
|
|||
You are correct, I haven't added any string since I didn't know how and what to add to make the current formula return "patient-janitorial". Do you have any suggestion?
|
#4
|
||||
|
||||
Could you please explain ( briefly but in plain English) what the conditions are to get one string or another so that we can understand the logic?
Thank you
__________________
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 |
#5
|
|||
|
|||
The first portion of the IF statement (logical_test) returns "Uni" (value_if_true) for certain item number, description, or location. And the rest (value_if_false) will return "mammo" if the item number is "MDT~", otherwise it returns "patient".
I thought I can add a string in the (value_if_false) that will return "patient-janitorial" if the item number starts with "D", but I wasn't successful. Please let me know if there are any other info needed. Thank you for your help! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple If Conditions | z941714 | Excel | 8 | 08-09-2015 04:12 PM |
formula needed to sum weeknum results from multiple worksheets | JOJO101 | Excel | 0 | 06-27-2015 11:06 PM |
Bookmarking Formula Results | Wyskers | Word | 3 | 11-09-2012 01:13 PM |
6 conditions formula | paconovellino | Excel | 2 | 03-05-2012 06:45 AM |
Count with multiple conditions | bundy5150 | Excel | 4 | 02-22-2011 10:00 AM |