#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Daily Variance Jose Aleman Excel Worksheet Functions 2 May 4th 06 06:49 PM
Pivot Tables - Variance and Variance % PJS Excel Discussion (Misc queries) 2 January 18th 06 04:12 AM
Calculate % variance on previous quarters. Quarter %, etc. pivot DaveC Excel Discussion (Misc queries) 1 August 8th 05 06:45 PM
Excel % Variance Formula........ BigDon Excel Worksheet Functions 5 June 7th 05 08:58 PM
Pivot Tables - Variance and % Variance fields CraigS Excel Discussion (Misc queries) 5 January 6th 05 01:22 AM


All times are GMT +1. The time now is 11:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"