Indirect question

Tuberockin · Mar 14th, 2002, 06:31 PM

Hi everyone,

I hope someone can help me with this little query.

I have a number calculated in A3 that I have rounded to 0 decimal places. I want to refer to this number in cell A1 and adding text after it.

As an example in A1 =indirect(A3&"text")

How can I make the number from A3 rounded in A1? When I try the above it calls a number of a large number of decimal places.

Thanks for your help.

anno · Mar 14th, 2002, 06:38 PM

=indirect(rounddown(A3)&"text") ?

Tuberockin · Mar 14th, 2002, 06:44 PM

Nope, no luck, thanks anyway.

I played around a little and entered the following but still no success:

=INDIRECT((ROUND(A3,0))&"text")

giving a #ref! error.

Mmm frustrating..

Tuberockin · Mar 14th, 2002, 06:46 PM

Ahh got it. Thanks anyway all.

Ended up placing the round formula in another cell and then referring to this new cell in cell A1.

ercstric · Mar 14th, 2002, 07:20 PM

try this,
a1=a3, in a2 enter the following:
=if(a1>0,"your text","")

there ya go!

now someone fix my gannt problem

cheers

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 06:31 PM	#1
Tuberockin New Member Join Date: Feb 2002 Location: Qld, Australia Posts: 12	Hi everyone, I hope someone can help me with this little query. I have a number calculated in A3 that I have rounded to 0 decimal places. I want to refer to this number in cell A1 and adding text after it. As an example in A1 =indirect(A3&"text") How can I make the number from A3 rounded in A1? When I try the above it calls a number of a large number of decimal places. Thanks for your help.

Mar 14th, 2002, 06:38 PM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	=indirect(rounddown(A3)&"text") ?

Mar 14th, 2002, 06:44 PM	#3
Tuberockin New Member Join Date: Feb 2002 Location: Qld, Australia Posts: 12	Nope, no luck, thanks anyway. I played around a little and entered the following but still no success: =INDIRECT((ROUND(A3,0))&"text") giving a #ref! error. Mmm frustrating..

Mar 14th, 2002, 06:46 PM	#4
Tuberockin New Member Join Date: Feb 2002 Location: Qld, Australia Posts: 12	Ahh got it. Thanks anyway all. Ended up placing the round formula in another cell and then referring to this new cell in cell A1.

Mar 14th, 2002, 07:20 PM	#5
ercstric New Member Join Date: Feb 2002 Posts: 16	try this, a1=a3, in a2 enter the following: =if(a1>0,"your text","") there ya go! now someone fix my gannt problem cheers