i want to combine the two formula into one formula... this formula calculate forex pips, but there different pairs with different decimal points,
=(M8-J8)*LOOKUP(I8,{"LONG","SHORT"},{1,-1})*1000
=(M8-J8)*LOOKUP(I8,{"LONG","SHORT"},{1,-1})*100
for an example i want to add currency pair name's( EURUSD, GBPUSD) to this formula so when i write the pair name this formula works for that currency pair
=(M8-J8)*LOOKUP(I8,{"LONG","SHORT"},{1,-1})*1000
and when i wright Yen pairs (USDJPY, GBPJPY) i want this formula to work
=(M8-J8)*LOOKUP(I8,{"LONG","SHORT"},{1,-1})*100
the point is i want the answer on the same column
more details attached
Bookmarks