View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mur Mur is offline
external usenet poster
 
Posts: 4
Default help with formula

variance analysis

cell A1 is 10 input
cell B1 is 5 input
cell c1 is 5 formula A1 - B1

I only want to look at variances that are greater than or less than 25% of
cell A1 I can create the formula and it works but if the variance is
negative because A1 is less than B1 then I can't get it to show a
variance..only 0

Any help would be appreciated...