The cell G6 with = E6 & C$3 × 20.57 / exchange rate in I6 cell = CURRENCY("GBP","EUR",0)
gives the correct answer in K6.
But the cells above G5 = E5 & C$3 × 79.41 / exchange rate in cell I5 = CURRENCY("GBP","EUR",0) gives error
"The operator “/” expects a number, but cell G5 contains a string"
They're all basically near identical? I got no string warning for K6?
MacBook Pro 15″, macOS 12.3
all of column G is set to automatic
If there were true Number or Currency values in G they would be right-aligned by default. It looks as if they are Text, because they are left-aligned. Trying to perform arithmetic on Text is not a winning strategy!
SG
Bardon,
Unless you tediously formatted each row in column G to a specific currency, you probably used one currency format for all. If so, most will likely appear to the Numbers engine to be text rather than currency. If I were you, I would enter all the Margin figures in C as pure numbers, not currencies. Then, the divide operator will not choke on the values.
Jerry
Cheers @JerroldGreen1, this is what is odd about the failure to get a result in K5 when K6 is working, because all of column G is set to automatic?
It makes no sense!
Thanks SGIII!
Same Formulas but Results in one Cell gives Error?
