MID formula question
I am trying to set up a MID formula. I entered "=MID(H2,D2,1)". I don't
want the H2 to be the cell, but rather I want the value that I entered into H2 to be the cell. In other words, in cell H2 I entered M12, and I want the formula to refer to M12 rather than H2. Any ideas on how to make the value of the cell (M12) be what the formula looks for rather than the cell H2? |
MID formula question
Look in the help index for INDIRECT
-- Don Guillett Microsoft MVP Excel SalesAid Software "Brian" wrote in message ... I am trying to set up a MID formula. I entered "=MID(H2,D2,1)". I don't want the H2 to be the cell, but rather I want the value that I entered into H2 to be the cell. In other words, in cell H2 I entered M12, and I want the formula to refer to M12 rather than H2. Any ideas on how to make the value of the cell (M12) be what the formula looks for rather than the cell H2? |
MID formula question
Try: =MID(INDIRECT(H2),D2,1)
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Brian" wrote: I am trying to set up a MID formula. I entered "=MID(H2,D2,1)". I don't want the H2 to be the cell, but rather I want the value that I entered into H2 to be the cell. In other words, in cell H2 I entered M12, and I want the formula to refer to M12 rather than H2. Any ideas on how to make the value of the cell (M12) be what the formula looks for rather than the cell H2? |
All times are GMT +1. The time now is 06:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com