if formula to meet multiple conditions

hi,

i need help with if formula. I have managed to get the formula to work when there is just 1 currency but when there are other currencies i need the formula to be able to adapt to multiple conditions so i can just drag the formula down and it works for all currencys

i have attached the spreadsheet and would appreciate any help on this matter.

thanks