View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mur Mur is offline
external usenet poster
 
Posts: 4
Default Variance Analysis and Excel

Cell A1 is 10 and input
Cell B1 is 5 another input
Cell C2 is 5 a formula A1 - B1

I want to only look at variances that are greater than 25% of cell A1 and i
can get that to work but if cell A1 is less than B1 then I can't get the
negative number to work. I want to look at all variances that are greater
than 25% of Cell A1 regardless of whether it plus or minus...