- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Conditional If then to return values for ranges
I have written a formula to flag runs in campaigns (ex: consecutive days above 19.) HOw can I create a formula that will then generate the production values specific for campaigns greater than 9 days? (Examples: campaign 1, 2, 3=>No value whereas campaigns showing 1,2,3,4,5,6,7,8,9 would show the appropriate number 19,20,21,22,23,24,25,26,27 etc.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Conditional If then to return values for ranges
I am not understanding exactly what you are looking for. Could you please provide a sample data table with the values you expect to see?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Conditional If then to return values for ranges
Perhaps this is a starting point, it checks, if the number of runs per campaign is greater or equal 9 days. However, it does not check whether days are consecutive, that's possible, but more complex. If that's needed, it would be really better if you could provide examples.
Key is the function "Col Number", see Scripting Index for details.