Results 1 to 8 of 8

Help with an IF OR Function

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2011
    Location
    England
    MS-Off Ver
    Office 2019
    Posts
    33

    Help with an IF OR Function

    Hi I have two columns of data that contain values from 1 to 9 as well as the value "U". In a third column, i'm trying to determine whether a cell is equal to or above 7 in the either of the columns and if it is enter an "e" and if not " enter a "-". I am using the formula below however if the it is still it is not working in that when a "U" is present it still enters an "e" instead of a "-". I have attached an example and a fourth column of what it should be showing. If someone could help i would really appreciate it.

    =IF(OR(A2>=7,B2>=7),"e",IF(OR(A2="U",B2="U"),"-","-"))
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-10-2023, 10:18 AM
  2. [SOLVED] Left function, Right Function, or Mid Function to extract values to three decimal places
    By bjnockle in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-08-2023, 03:22 AM
  3. Right function, Left function, Mid function to extract values in column A
    By bjnockle in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 06-14-2020, 03:14 PM
  4. COUNTUNIQUE Function in Google Sheets; Excel lacks a direct counterpart to this function?
    By PivotTablePSHomage in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2018, 05:27 AM
  5. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  6. Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  7. Replies: 1
    Last Post: 03-21-2012, 11:22 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1