+ Reply to Thread
Results 1 to 4 of 4

Time series result based on cerain criteria

  1. #1
    Registered User
    Join Date
    03-20-2023
    Location
    Croatia
    MS-Off Ver
    Software Microsoft Office 2021 Home & Student
    Posts
    18

    Talking Time series result based on cerain criteria

    Hi all.

    I have a time series in column A, a condition in column B and result in column C. If a condition in column B is greater than -50, then result in column C should be equal to column A. However, if criteria in column B reaches -50 or below, then result in column C is 10 times greater than in column A. Now comes the hard part: next cells in column C should also give a result that is 10 time greater than in corresponding cell in column A until critera in column B reaches 0. I've made an example in a sheet and desired result in column C.

    Your help is greatly appreciated!
    test2.xlsx

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,908

    Re: Time series result based on cerain criteria

    The following formula returns the values posted in column C:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    03-20-2023
    Location
    Croatia
    MS-Off Ver
    Software Microsoft Office 2021 Home & Student
    Posts
    18

    Re: Time series result based on cerain criteria

    Thank you so much for your help!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,908

    Re: Time series result based on cerain criteria

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ 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. [SOLVED] Macro to retain cerain Data in Col A
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2021, 12:19 AM
  2. [SOLVED] Weighted Average of Sequential Time Based Data Series Using Start/End Time Input
    By marcoyul in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2017, 12:10 PM
  3. Need formula to count score based on criteria (0/1 variable, time series)
    By wintheranders in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2015, 07:08 AM
  4. Need formula to count score based on criteria (0/1 variable, time series)
    By wintheranders in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-25-2015, 04:57 AM
  5. Cut and paste an entire row to another sheet if a cerain criteria is met
    By julia_helena in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-12-2014, 01:53 PM
  6. Charting time series based on different scenarios
    By _keith in forum Excel General
    Replies: 7
    Last Post: 01-08-2011, 06:41 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1