Try to figure out how to display the value from a cell when the IF.OR function is executed.
Here is my function (does not work):
= IF ($ P $ 14 = ""; ""; IF (or ($ P14 = "PALETTE"; "$ H14"; "$ L14"))
The function should be empty if it is empty, but show the value of cell "H14" if P14 = pallet. If different, the value of cell "L14" is displayed.
Thank you all for the help.