INDIRECT Function wont work in this case?

[andretigana]

I need to calculating percentage used of raw materials, formula shows below

My raw material is a sheet with origin dimension 1000x1000 mm2
the usage of material only 200x200 mm2

so my formula written below:

A1
=(200*200)/(1000*1000)

Printed
=0.04

the problem is when printed results only

So I make formula

A1 B1 C1
=200*200 =1000*1000 =A1/B1

Printed
A1 B1 C1
40000 1000000 0.04


what i want in efficiently:
A1 B1 C1
200*200 1000*1000 =INDIRECT(A1/B1)

Printed:
A1 B1 C1
200*200 1000*1000 #REF!

See, A1 and B1 is without equation.


how to correct indirect function above so the printed will show below:
A1 B1 C1
200*200 1000*1000 0.04


thanks in advance.

[Pete_UK]

You don't use indirect like that. It is used to convert a text string which represents an Excel reference into the actual reference, but the result (of 0.04) is not a valid Excel reference. I'm not sure why you think you need to use the INDIRECT function for this - what is wrong with =A1/B1 in C1 ?

Pete

[andretigana]

thanks for reply pete,

the function is for Dynanic function, =A1/B2 cant show what is calculated in printed because A1 is also not visible by reader.

I use Excel table, but adding more column is not efficient example E1 = (A1*B1)/(C1*D1).

Messy, to much column.

sometimes in work or business proposal, when dimension change i forgot to change the formula

i will forget change the data inside a formula if writing Arithmetic directly.

Instead of INDIRECT, what function can help this?

A1
1+2 without equation in beginning

or
A1
'1+2

B1
=INDIRECT(A1)

#REF!

what I want

B1
3

Andre

[JeteMc]

If I understand correctly the following formula will do what you want, display 1+2=3, providing that each factor is in a separate cell, (after all Excel provides 16,000+ columns) i.e. 1 is in A1 and 2 is in B1:

Please Login or Register  to view this content.

Same would be true for displaying (200*200)/(1000*1000)=0.04.
Place 200 in A2, 1000 in B2 and use the following formula:

Please Login or Register  to view this content.

Let me know if you have any questions.