Calculation Issues.

**AV1D** · 01-20-2012, 03:48 PM

Hi All,

I am currently working on a workbook that populates various sheets inside the workbook, however i cant get my head round why something wont calculate.

Sheets
Front
Middle
Back
etc etc

So

Middle

(CELL A2)=MID(front!E16,8,5) (Which belongs to (AQ000)0.658"L") so the cell has been told to grab 0.685, in which it has and put into A2, A2 is formated as Number however the =MID(front!E16,8,5) is formated as text

(CELL A3)=3750*A2 which results in 0, when follow the formula in Evaluate Formula, it shows 3750*A2 when i step down it then shows, 3750*"0.685"

Is there anyway to calculate the 0.685 without the "" but keeping formula in A2?

Thanks in advance

**tigeravatar** · 01-20-2012, 03:58 PM

AV1D,

Put -- in front of the MID formula in 'Middle'!A2, so that it looks like this:
=--MID(front!E16,8,5)

**AV1D** · 01-20-2012, 04:06 PM

Originally Posted by tigeravatar

AV1D,

Put -- in front of the MID formula in 'Middle'!A2, so that it looks like this:
=--MID(front!E16,8,5)

When i do that, the cell populates 0.0 insted of the 0.685

**tigeravatar** · 01-20-2012, 04:26 PM

AV1D,

Couldn't tell you why. Here's an example workbook based on the criteria described and using the earlier solution provided and it works just fine...

**AV1D** · 01-20-2012, 04:59 PM

I managed to get it working, must be some sort of issue floating around between sheets.

Aslong as i can get them to link how i want them and the calulations do there jobs ill be alright.

Thanks for your help mate