Don't want if statement to return "false"

mbesspiata · #1 05-11-2016, 09:05 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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