Dear all,
Here is my problem:
...
Please Login or Register to view this content.
W, X, Y, Z are float numbers
I want:
Currently when I apply the first formula to C5=C4/B5 and repeat the same formula for other cells (at the bottom corner of the cell where the pointer changes to '+' symbol), the result is:Please Login or Register to view this content.
Which is not desirable.Please Login or Register to view this content.
How can I do that? hope that I state the problem clearly.
Last edited by mahmoodn; 11-04-2011 at 09:02 AM.
Make C5= C$4*B5
(The $ acts as an anchor to stop the row or column changing when the formula is dragged)
In C5
=$C$4*$B5
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
ok thanks. Both work as I want
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks