LinkBack URL
About LinkBacks
In cell H1, I want to multiply the value in cell B[x] by $G$1 where x is given in cell A1. For example, if A1 is 4, I want to to multiply B4 by $G$1 and have the result in H1.
In cell H1, I want to multiply the value in cell B[x] by $G$1 where x is given in cell A1. For example, if A1 is 4, I want to to multiply B4 by $G$1 and have the result in H1.
I would probably use the =INDEX() function http://office.microsoft.com/en-us/ma...776.aspx?CTT=1
=INDEX($B$1:$B$100,A1)*$G$1
Originally Posted by shg
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks