Example Scenario: where my formula tests whether the value in column A equals
a multiple of 5. The result is displayed in column B.
Call No. Meet Formula?
1
2
3
4
5 Y
6
7
8
9
10 Y
Total 2

So, from the list above, I know that the 5th and 10th call will meet the
formula.

Problem:
My formula is a lot more complicated than just checking for multiples of 5
and I have to run the formula per row (it will be a v long explanation if you
wanna know why). Is there a way such that I just enter "20" in one cell and
the formula gives me a result of "5, 10, 15, 20" (using the multiple of 5
example)?

I wish I can share my spreadsheet with the formula with an expert. Any
volunteers?