Forum Discussion
[@header]] show up instead of number
Good afternoon,
I have problem with my excel file after imported it from a txt CSV. File.
I want to calculate the unit price of my product but when I select the cell in the column "sale" and the other in the column "order quantity" the formula shows as [@sales]]/[@order quantity]]
When I enter to get the result the message "value" appears.
I try to find the source of the problem but didn't found out.
If someone could help me on this point 🙏
2 Replies
Annesoblt You are obviously working in a structured excel table. That's good! The type of formula you mentioned uses structured reference with the @-sign (meaning "take the cell on the same row") followed by the column and with some square brackets. However, based on the column names you provided the formula should look like this:
=[@sales]/[@[order quantity]]and if you would use a column name like OrderQty, it would look like this:
=[@sales]/[@OrderQty]The extra pair of bracket in the first formula is due to the space in the column name.
You don't really have to worry about that as Excel does this automatically when you construct the formula by pointing at the cells.
Riny_van_Eekelen thank you very much for your reply.
Over the time I looked for a solution I found that some of my data were still in text format. This is why it wasn't possible for me to use any formula.
