Hi Guy
I have an array formula which calculate the difference in between several values, usually the max value in a range to take away he minimum value in another rage.
Here are my data samples:
2013 2014 2015 2016 (Expected Results)
323 232 123 234 Show difference of 323 - 123 (Max of 2013 and 204 - Min of 2015 and 2016)
233 - - 232 Show Blank Because 2015 is empty
88 34 Show difference
23 23 978 show differences
22 Show Blank BUT the actual result displayed was 22. So how change my formula so that I can ignore this when there is only 1 result?
My current formula
=IF(2015 Score="", "", MAX(2013:2014)-MIN(2015:2016)))
I understand the use of Countif range is = 1, IF(2015 Score="", "", MAX(2013:2014)-MIN(2015:2016))) .
But how do I fuse these two functions together?
So what I want is, If 2015 is blank, then don't calculate, otherwise, calculate. and IF range counted with 1 value, then Don't calculate, otherwise, calculate.
Feel free to change 2013:2014 into columns.
Please help.
Thank you
I have an array formula which calculate the difference in between several values, usually the max value in a range to take away he minimum value in another rage.
Here are my data samples:
2013 2014 2015 2016 (Expected Results)
323 232 123 234 Show difference of 323 - 123 (Max of 2013 and 204 - Min of 2015 and 2016)
233 - - 232 Show Blank Because 2015 is empty
88 34 Show difference
23 23 978 show differences
22 Show Blank BUT the actual result displayed was 22. So how change my formula so that I can ignore this when there is only 1 result?
My current formula
=IF(2015 Score="", "", MAX(2013:2014)-MIN(2015:2016)))
I understand the use of Countif range is = 1, IF(2015 Score="", "", MAX(2013:2014)-MIN(2015:2016))) .
But how do I fuse these two functions together?
So what I want is, If 2015 is blank, then don't calculate, otherwise, calculate. and IF range counted with 1 value, then Don't calculate, otherwise, calculate.
Feel free to change 2013:2014 into columns.
Please help.
Thank you
