Excel help with arrays and formulas

Hi,

I needed help with coming with an Excel formula and not a vba code.

I am have attached a sample data excel with Input and Output.

Basically, the code will need to go through all the rows under input and output the data as shown. If Column G is negative then, the B colomn currency gets shows under M and if it is positive then under colomn K.

Please help

Thanks

Hi,

here is the VBA forum, you should move to Excel formula forum !