|
|
#1
05-11-2016, 09:05 AM
|
|||
|
|||
Don't want if statement to return "false"
I have multiple if statements in a formula which I want the "if false" to return the value of cell instead of the work "false". How do I do that? Here is my current statement where I have categories listed in a column. I want this formula to check and if it does not equal either VEH, VES, OR AIR then it should place "GP" in the cell. I get all the "GP" showing but instead of returning the veh, ves, or air value from the cell I get the "false".
=IF(E6<>"VEH",IF(E6<>"VES",IF(E6<>"AIR","GP",E6))) I want the value of E6 to show and not the word "false". It's really bugging me. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Error: "Changes made were lost...reconnect with server", when switching "from" field | randhurrle | Outlook | 2 | 02-25-2015 06:51 PM |
| How do I delete the names under "Exceptions" when I use the "Restrict Editing" feature in Word? | MengS | Word | 0 | 02-25-2015 02:57 PM |
| remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
 IF statement just generates text "MERGEFIELD" in document - what am I doing wrong?
|
Eri | Mail Merge | 1 | 03-03-2012 03:03 PM |
|
How to choose a "List" for certain "Heading" from "Modify" tool?
|
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode