Can someone help me with a formula in column D to generate 'Result' meeting 3 conditions?

Thanks in adv.

<tbody>

</tbody>

E2 condition: A<B

F2 condition: B<C

G2 condition: A<C

E3 condition: A<B

G3 condition: A<C

F6 condition: B<C

G7 condition: A<C

Thanks in adv.

**Sheet1**A | B | C | D | E | F | G | |

1 | Result | Condition 1 | Condition 2 | Condition 3 | |||

2 | 300 | 400 | 500 | 1 | A<b< td=""></b<> | B<c< td=""></c<> | A<c< td=""></c<> |

3 | 300 | 600 | 500 | 2 | A<b< td=""></b<> | B>=C | A<c< td=""></c<> |

4 | 300 | 400 | 200 | 3 | A<b< td=""></b<> | B>=C | A>=C |

5 | 300 | 200 | 100 | 4 | A>=B | B>=C | A>=C |

6 | 300 | 200 | 250 | 5 | A>=B | B<c< td=""></c<> | A>=C |

7 | 300 | 200 | 500 | 6 | A>=B | B>=C | A<c< td=""></c<> |

<tbody>

</tbody>

E2 condition: A<B

F2 condition: B<C

G2 condition: A<C

E3 condition: A<B

G3 condition: A<C

F6 condition: B<C

G7 condition: A<C

Last edited: