Forum Discussion
Multiple Variable Calulation
Hi there, I'm sorry to ask as I'm sure this is a standard query, but have been searching and trying for some time and can't quite get the answer to what I am trying to do. Please see some simpli...
Hi some_bih thanks for the reply. I agree it should be a simple if formula and i've tried to do this in a calculated column. But I'm not sure how to make it lookup using the job field against those multiple variables at once. Currently, I can only see a way of doing it making multiple calculated columns for my 3 questions. Could you suggest the formula to use?
