adding statement to give the values that do not appear

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
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
 
Break this up into a nested if statement as follows

=IF(O2358="ba","BA",IF(O2358="dr","DR",""))
 
Back
Top