ps. ...however, a colleague from Finland suggests that English will be
used in Excel in Sweden as well

A

Anthony D wrote:
Hi Freddie,

It seems that the Swedish for "or" is "eller".
(from http://www.xldennis.com/Ordlistaes.htm )
:)

Anthony


"FreddieP" wrote:

Hi Anthony, I don't suppose you know the word for "or in the formula in
swedish excel versions :)

/Freddie


Anthony D wrote:
Hi,

A warning can be constructed in another cell, say in b1:

=IF(OR(A1(1.2*a2),A1<(0.8*a2)),A1&" !",A1)

Or it would be possible to use conditional formatting on cell a1.
With a1 selected, Format, Conditional Formatting ... ,
Cell Value Is not between =a2*1.2 =a2*0.8
Format... Font, Border, Patterns

Anthony

"FreddieP" wrote:

Hi, I would like to get a waring in a ell that if one cell has a higer OR
lower value than another specific cell (decided by me).

I want to use percent to specify the variance. If cell A1 differs up OR down
from cell A2 with more than 20% I want it to return lets say a "!".
/FReddie