Need help with #VALUE! error

[leopardhawk]

Hello forum friends,

Can someone please tell me why this formula is giving me the #VALUE ! error?

"&TEXT(D36/(tax_tables!C39),"0%")&"

The value in D36 is $1227.32 and the value in tax_tables!C39 is $1154.58.

I want to display the result as a percentage.

The formula is a smaller part of a CONCATENATE string, hence the TEXT. I can get it to display dollar amounts, no problem, but I would like the percentage to work.

Thanks!

 

[James006]

Hello,

The formula as shown ... is correct ...

=TEXT(D36/(tax_tables!C39),"0%")

You should check elsewhere in the concatenation ...

 

[Fluff]

Also make sure that both D36 & C39 are numbers, not text.

 

[leopardhawk]

You are correct, I tried changing the formatting to 'number' and 'accounting' but neither one of those worked. There must have been some weird formatting in the cell (tax_tables!C39) though, because when I dragged down the cell above it to copy down, the error disappeared! Go figure.

Thanks for you help!

 

[Fluff]

Glad it's sorted & thanks for the feedback.

For reference, changing the format of a cell does not change the underlying value of the cell. If you enter a number as text & change the cell format, the cell contents will still be text.