Hi, I am having a problem with a multiple IF statement and would really appreciate some help: I need to expand the formula I have used below to ignore the '0' values in columns A,B and C (from, middle and to).
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
I have given an example of this above, where the From heading sits in cell A1 and reads logically from left to right, top to bottom. The whold formula is based on the dominant value - that if "from"= "to" then use the "to" value but if from does not equal to then use the "middle" value. My problem is that where there are "0" values in the from, middle or to columns I get a '0' value returned whereas I would like a "" returned whilst still retaining the 'dominant' value where there are values in the 3 columns, ignoring the '0' values.
Could anybody please help with a way around this?
Thank you in advance.
from | middle | to | Formula used: | answer |
MP | MP | MP | =IF(A2=C2,A2,B2) | MP |
0 | MP | MP | =IF(A2=C2,A2,B2) | MP |
MP | 0 | MP | =IF(A2=C2,A2,B2) | MP |
0 | 0 | 0 | =IF(A2=C2,A2,B2) | 0 |
0 | 0 | MP | =IF(A2=C2,A2,B2) | 0 |
MP | MP | 0 | =IF(A2=C2,A2,B2) | MP |
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
I have given an example of this above, where the From heading sits in cell A1 and reads logically from left to right, top to bottom. The whold formula is based on the dominant value - that if "from"= "to" then use the "to" value but if from does not equal to then use the "middle" value. My problem is that where there are "0" values in the from, middle or to columns I get a '0' value returned whereas I would like a "" returned whilst still retaining the 'dominant' value where there are values in the 3 columns, ignoring the '0' values.
Could anybody please help with a way around this?
Thank you in advance.