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.

For instance:

=IF((E6<>"VEH")*(E6<>"VES")*(E6<>"AIR"),"GP",E6)

Your formula:
Let's say you have VES in E6, then the first argument E6<>"VEH" evaluates to TRUE so the formula now is: =IF(TRUE,IF(E6<>"VES",IF(E6<>"AIR","GP",E6)))
Then the first argument of the second IF E6<>"VES" is evaluated to FALSE and the formula is reduced to: =IF(TRUE;FALSE) which returns FALSE.

Try to use the Evaluate Formula tool on your formula and I think it will become clear.

=if(or(e6={"veh","ves","air"}),e6,"GP")