Forum Discussion
Formula Help Please
I have an average number in one cell and if it falls in between 2 numbers located in 2 seperate cells i want it to read "Pass" or "Fail" if it's outside the parameters in a seperate cell.
Hi Zachary,
1) It's misprint in your formula, correct syntax as in Vladislavs' post
2) I really don't understand why Detlefs' variant is complex and/or less preferable...
Thanks for pointing out the forgotten peren. To me cell references use less features than named ranges, which makes it easier and less complicated. The functionality will be the same, but referencing cells instead of named ranges seems easier to me.
- I'd second you as long as things are neat and small. The more complex things tend to get the more you'll love the self-explaining nature of named ranges I'd assume. But in the end that's personal taste as long as there are no conventions to be met.
- Thanks Peter, you're right that named ranges become more useful once sheets get more complex. Chris's sheet looks quite simple, but definitely something worth noting, thanks! Alles beste!
