MS Excel Question: IF Function
Is there a better way than this to code IF statements in a worksheet?
Code:
=IF(H8=1, A1, IF(H8=2, A2, IF(H8=3, A3, A4)))
As the code shows, the common reference cell is H8 and the IF statement checks it's value (from a range of 1-3) and then makes the target cell equal one out of a range of cells depending on the outcome.
This is a short example but I have some very long and complex IF statements that use this method and was wondering if there was a way to simplify e.g. by using array formulas or something similar?
Something along the lines of:
Code:
=[IF(H8 = 1;2;3, A1;A2;A3, A4)]
That obviously doesn't work but that's the kind of thing I was thinking.
Cheers
-Rob
1 Attachment(s)
Re: MS Excel Question: IF Function
You can use either the VLOOKUP or HLOOKUP functions. They will check a rnage of cells for a particular value and make it equal to a cell in the range. Have a look at the attached file for an example.
