Hi there,
I am in the process of getting back to doing some more advanced things with Excel and it seems some of my knowledge has got rather rusty!
What I am trying to do is create a function to look at a range of cells and evaluate based on 3 possible conditions, if all the cells have value A then return A, if any cell has value B but none have value C then return B, if any cell has value C then return C, I've tried a couple of different ways, once with AND functions and I also tried a great long set of nested IF functions and neither worked for me, any help would be greatly appreciated. I am using Excel 2013 and ideally I want to do this with formulas/functions rather than macros.
Thanks very much,
Skaar
I am in the process of getting back to doing some more advanced things with Excel and it seems some of my knowledge has got rather rusty!
What I am trying to do is create a function to look at a range of cells and evaluate based on 3 possible conditions, if all the cells have value A then return A, if any cell has value B but none have value C then return B, if any cell has value C then return C, I've tried a couple of different ways, once with AND functions and I also tried a great long set of nested IF functions and neither worked for me, any help would be greatly appreciated. I am using Excel 2013 and ideally I want to do this with formulas/functions rather than macros.
Thanks very much,
Skaar
