ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel Formula and Variance Analysis (https://www.excelbanter.com/excel-worksheet-functions/252613-excel-formula-variance-analysis.html)

Mur

Excel Formula and Variance Analysis
 
Cell A1 is 10 an input
Cell B1 is 5 an input
Cell C1 is 5 a formula of A1 - B1

I want to only see variances that are greater than 25% of cell A1 and I can
get that to work but if cell A1 is less than 5 in the above example I can't.
I want to see 25% of cell A1 regardless of whether the variances is positive
or negative

Any help would be appreciated........


All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com