Hi guys!
I have a formula that I want to copy to the cells under, but I only want it to add sequence number to some part of the formula.
This is the code:
=HVIS(Q5=1,(Satser!AL5*S5),0)
I am trying to drag the cell (dragging from right bottom corner) down, so it will add numbers.
The problem is that I only want it to add numbers to "(Satser!AL5" and to "*S5 and not to "Q5=1"
Is there a way I can do this in easy way?![]()
Bookmarks