toony
New member
Hi,
The below formula shows empty cell if “ba” or “dr” do not appear in cell O2358. However, is there another statement I could ad to add to it, so that also will give me “BA” or “DR” appear, depending on which of these 2 values (BA or DR) is on cell 02358.
=IF(NOT(OR(O2358="ba",O2358="dr")),"").
Many thanks
The below formula shows empty cell if “ba” or “dr” do not appear in cell O2358. However, is there another statement I could ad to add to it, so that also will give me “BA” or “DR” appear, depending on which of these 2 values (BA or DR) is on cell 02358.
=IF(NOT(OR(O2358="ba",O2358="dr")),"").
Many thanks