Sorry, I said no If()! ;) I wanted something shorter and cleaner just for readability's sake. I already have loads of functions in this sheet that are like If(foo,If(foo2,If(foo3...),...,...)" and I am trying to improve on that.Originally I was going to just use "x/x" and deal with the #Errors, but IFERROR seems like it can add a level of not-too-verbose polish to that which is why I said I'd most likely use that.
–
stuporuserJul 1 '11 at 21:52

Yes and sorry if my shorthand wasn't clear but the ternary was what I meant by "If(whatever)". There doesn't really appear to be an "If(whatever)"! I think "If(whatever,,)" is the simplest valid construction. But to be hyper-specific, when I originally wrote "whatever", what I actually meant was "logical_test, [value_if_true], [value_if_false]" ;)
–
stuporuserJul 1 '11 at 21:56

Well, you do want something piecewise, which you cannot construct out of analytic expressions like x/x alone: continuous functions of continuous functions are continuous. What's the problem with having an IF? Maybe a a MAX will do?
–
Kerrek SBJul 2 '11 at 1:13

IF() seems like the correct choice from a semantic point of view. Aren't you just trying to be clever for clever's sake otherwise?
–
Chris KentJul 2 '11 at 12:23

Unless we are misunderstanding what it is you are looking for, from your question it appears you want one value if the value of 'X' is true and another if 'X' is false. This meets that requirement.
–
SargeNov 19 '12 at 18:51