+ Reply to Thread
Results 1 to 3 of 3

with a condition in a cell

  1. 07-02-2022, 05:31 AM #1
    aslam5420
    aslam5420 is offline
    Registered User
    Join Date
    06-29-2022
    Location
    Canada
    MS-Off Ver
    2021
    Posts
    38

    with a condition in a cell

    Hi,

    [B]I have value of +1 in cell B3. If value is +1 in Cell B3 then I want a series of +1 an
    Last edited by aslam5420; 07-10-2022 at 10:06 AM.
    Reply With QuoteRegister To Reply
  2. 07-02-2022, 05:57 AM #2
    Phuocam
    Phuocam is offline
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,907

    Re: Formula to create a Custom series of alternate +1 and -1 with a condition in a cell

    Try this in D4:

    =-B3

    In D5 and copy down:

    =-D4
    Reply With QuoteRegister To Reply
  3. 07-02-2022, 06:06 AM #3
    aslam5420
    aslam5420 is offline
    Registered User
    Join Date
    06-29-2022
    Location
    Canada
    MS-Off Ver
    2021
    Posts
    38

    Re: Formula to create a Custom series of alternate +1 and -1 with a condition in a cell

    Hi Phuocam

    Thanks a lot it worked
    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. [SOLVED] Custom written TEXTJOIN - How to alternate delimters
    By GreedyG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2019, 06:18 AM
  2. Alternate cell substitution based on condition
    By phodges in forum Excel General
    Replies: 8
    Last Post: 07-01-2019, 10:43 PM
  3. How to create a custom sum series?
    By kooldis in forum Excel General
    Replies: 3
    Last Post: 02-19-2016, 04:26 PM
  4. [SOLVED] create a series of cell values from the concateneation of 2 lists based on a condition
    By dpen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-28-2013, 07:15 AM
  5. [SOLVED] Formula to Pick Condition-Meeting Cells and Copy Them to Alternate Worksheet
    By SpeshallEd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-10-2012, 07:57 PM
  6. Alternate Color Lines when using Custom Views
    By GLT in forum Excel General
    Replies: 7
    Last Post: 11-13-2005, 10:55 AM
  7. Alternate shading based on series of numbers in 3 columns
    By Ozbobeee in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-20-2005, 03:05 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