Let’s say i have this situation:
1.ods (31.3 KB)
How can i test each row so that it returns true only on the last row where the powered number is greater than 0, all the other to be false. In this case there would be 4 trues.
Also, i don’t know how to fix the increment thing, so it starts each time from a value >1 when the first value <1 is encountered.
How should i proceed?
Thank you.
But you didn’t specify which exact cells should show those “trues”?
Also, it would be nice if your screenshot showed the column and row labels: now it’s problematic to make sense of formulas. (And it’s good to allow others to see the problem before downloading stuff.)
This means, “I expect “true” in cell X5, cell Y10, …” ? Please be specific.
@mikekaganski
Yes, it can happen multiple times on a column, not just once.
In this case it would be on 04/02, 11/02, 20/02, 24/02.
All the other cells to be false.
Sigh.
So, if you can’t type “I want to see “true” in G10, G14, G24, and G29 - because they correspond to E10, E14, E24, and E29, which are all the last 0 in adjacent zero series; and all other cells in G must be false” - you can’t expect others to guess that from purely textual description.
Try
=AND(E2=0;OR(E3<>0;ISBLANK(E3)))@mikekaganski
I’m looking for a formula that calculates that, it isn’t always on those cells.
I can’t explain otherwise but with words.
For example: the first number, 1.0402, is the last entry before a 0, so it should show next to it “true”, same with 0.0122 and so on.
It is not the last 0, but the last value before a 0.
It doesn’t matter if it’s “always in those cells”. You provide a sample; and you explain exact expectation in that sample. You get the suggestion based on that sample. And then you adjust them as you need.
The better and more precise your task is, the easier it is for the reader. The reader doesn’t care how you modify the formula later.
(post deleted by author)
https://en.wikipedia.org/wiki/XY_problem
please tell about the task, (NOT about how you think to juggling with spreadsheets)
Formula
=AND(E2>0,OR(E3=0,ISBLANK(E3)))
Can you help me please also with the increment column, how to make it work past the first few numbers? I don’t know what i’m doing wrong.
It should start again from a value >1 when the first value <1 is encountered. As you can see, it starts from 0.01 or less.