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?
Last edited by cptolsen; 09-11-2019 at 08:58 AM.
Maybe $Q$5, that is, make it absolute.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
That solved my problem :DOriginally Posted by TMS
Thank you so much!!!
Last edited by cptolsen; 09-11-2019 at 11:27 AM.
Or maybe just $Q5
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks