Return a value based on other cell values

[Ravana]

I have four loan types in my organization. I am trying to get what type of loan exists based on the cell value.

SUPPOSE A1 TO A4 ARE ADVANCE TYPES AND B1 TO B4 ARE AMOUNT REALIZED AGAINST THE ADVANCES AS GIVEN BELOW:

FEST ADV 1000
CONV ADV 3000
PF ADV 5000
HBA ADV 2500

IN THE ROW A6 I HAVE ADVANCE TYPE; AND IN B6 BASED ON THE VALUES IN B1 TO B4 TO RETURN THE ADVANCE TYPE.

IF ALL ADVANCES ARE ZERO, THEN IN ROW B6 SHOULD BE BLANK
IF ALL ARE NON-ZERO, THEN B6 = FEST ADV, B7 = CONV ADV, B8 = PF ADV, B9 = HBA ADV
IF FEW ARE ZERO AND FEW ARE NON-ZERO, THEN RESPECTIVE NON ZERO ADVANCE TYPES ARE TO BE FILLED ON B6 TO B9

[udprocks]

Hi ravana,

It really great if u add a sample file for it with excpected result show it manualy if possible,

[Ravana]

I figured it anyway.

Thanks guys !!