Variance

F

FreddieP

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
 
A

Anthony D

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
 
F

FreddieP

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

/Freddie
 
Top