Posted to microsoft.public.excel.misc

FreddieP

external usenet poster

Posts: 24

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 03: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 12:22 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us