+ Reply to Thread
Results 1 to 4 of 4

Continuation of IF formula

  1. #1
    Registered User
    Join Date
    01-28-2023
    Location
    Uk
    MS-Off Ver
    Google sheets
    Posts
    12

    Continuation of IF formula

    Hi,

    I have an IF formula that works for me but I have to drag it down to work on other colums. It's currently
    =IFS(M5:M="AO","S",M5:M="","")

    Id like it to be automatic on every column. I have attached an example relation to the prior mentioned formula. Basically I need "s" to appear in column P when I type "AO" in column M. I think it may be an array formula. I've tried searching for this on YouTube to no avail.

    Be grateful if you could help.

    Thanks,

    Chris
    1.png

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Continuation of IF formula

    Moved to Googlesheets subforum.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    04-07-2019
    Location
    Turkey-Ankara-Çubuk
    MS-Off Ver
    Office 2010
    Posts
    50

    Re: Continuation of IF formula

    Hi, try this..
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    01-28-2023
    Location
    Uk
    MS-Off Ver
    Google sheets
    Posts
    12

    Re: Continuation of IF formula

    That works perfectly. Thanks for taking the time in helping me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 04-15-2018, 04:39 PM
  2. [SOLVED] Get the values on row by row (Continuation)
    By jrahm23 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-11-2016, 04:57 AM
  3. Continuation of formula doesn't work
    By mitjakleczka in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2014, 01:17 PM
  4. Line continuation
    By Wedge120 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-06-2010, 11:48 PM
  5. Continuation cells??
    By north.penny in forum Excel General
    Replies: 2
    Last Post: 01-28-2009, 08:35 AM
  6. Continuation of an Offset
    By Ashley Excel in forum Excel General
    Replies: 5
    Last Post: 01-19-2009, 09:23 AM
  7. [SOLVED] continuation from yesterday
    By Mindy in forum Excel General
    Replies: 4
    Last Post: 06-22-2006, 06:15 PM

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