Trying to figure out how to use a variable, which contains an address of a value, in a formula.
In the MTBF section i want the formula to divide by Fr which is a variable containing an address. I want the value of that address used in the formula.
Please Login or Register to view this content.
Last edited by Dewy; 11-10-2010 at 11:34 AM.
To make the formula work, you can put:
Please Login or Register to view this content.
But if you want the value in column K that you just calculated, you'd need to put:
Please Login or Register to view this content.
Regards
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
Thank you for the reply, but i was asking more along the lines of obtaining whatever the value of the address would be, not just the value. However solved it with this...
Please Login or Register to view this content.
OK, glad you got what you needed.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks