+ Reply to Thread
Results 1 to 2 of 2

Google Spreadsheet Query: Logical Formulas required

  1. 10-15-2021, 04:34 AM #1
    Natalie Lim
    Natalie Lim is offline
    Registered User
    Join Date
    10-15-2021
    Location
    Malaysia
    MS-Off Ver
    10.0.19043 Build 19043
    Posts
    1

    Red face Google Spreadsheet Query: Logical Formulas required

    I would like to create a formula to auto-detect if E2 or F2 is equal to "Pass", the Score will be 100%. Please assist with my query. Thanks in advance

    Google Spreadsheet.jpg
    Reply With QuoteRegister To Reply
  2. 10-15-2021, 04:35 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Google Spreadsheet Query: Logical Formulas required

    Welcome to the forum.

    I suspect it will be very similar to Excel:

    =IF(OR(E2="Pass",F2="Pass"),100%,"")
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Google Spreadsheet Function - Code Required for performing an operation
    By evilcreature in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 04-12-2021, 05:44 AM
  2. Is Query function of Google spreadsheet like available in MS Excel
    By paradise2sr in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 07-02-2019, 07:24 AM
  3. Is Query function of Google spreadsheet like available in MS Excel
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2019, 07:23 AM
  4. [SOLVED] Logical Function Help Required
    By stillyours786 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-22-2018, 07:51 AM
  5. google excel spreadsheet not auto-populating with formulas, but skipping row of data entry
    By dzm in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 9
    Last Post: 05-12-2013, 09:55 PM
  6. Logical values help required
    By kamalthakur in forum Excel General
    Replies: 2
    Last Post: 01-15-2010, 02:19 AM
  7. Logical construct required
    By tanksalevikrant in forum Excel General
    Replies: 2
    Last Post: 10-29-2007, 11:24 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1