Results 1 to 2 of 2

Thread: adding statement to give the values that do not appear

  1. #1

    adding statement to give the values that do not appear



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    Break this up into a nested if statement as follows

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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •