Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variance
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variance
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variance
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variance
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variance
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variance
.... however, according to a colleague from Finland, it is probably the
case that English ("or")is used in the Swedish formulae 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Daily Variance | Excel Worksheet Functions | |||
Pivot Tables - Variance and Variance % | Excel Discussion (Misc queries) | |||
Calculate % variance on previous quarters. Quarter %, etc. pivot | Excel Discussion (Misc queries) | |||
Excel % Variance Formula........ | Excel Worksheet Functions | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) |