ExcelBanter - Variance Analysis and Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Variance Analysis and Excel (https://www.excelbanter.com/excel-worksheet-functions/252615-variance-analysis-excel.html)

Mur

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...

Fred Smith[_4_]

Variance Analysis and Excel

Assuming your variance is in C2, try this:
=if(abs(c2)/Abs(a1).25,...)

Regards,
Fred

"Mur" wrote in message
...
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...

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