Thread: [Solved] Don't want if statement to return "false"
View Single Post
 
Old 05-11-2016, 09:05 AM
mbesspiata mbesspiata is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Angry 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.
Reply With Quote