Forum Discussion
Solved
Identify values and then display the content of the cell.
I am trying to set up a questionnaire that self populates the results. I have the answers given to 9 questions of 7 sections in a table (table is 9x7) Seen below: Each column is then summed, a...
Thank you dscheikey,
Is it possible to do the same with either cells F16:H18 or B16:D18 which are the cells I would like blank if all the cells in B2:J8 are zero?
Many thanks in advance
Nick
Is it possible to do the same with either cells F16:H18 or B16:D18 which are the cells I would like blank if all the cells in B2:J8 are zero?
Many thanks in advance
Nick
J16 is the alternative to B16 and N16 is the alternative to F16.
I just left the old calculations and created the alternatives with IFERROR() next to them. I thought you would recognise that.