Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
120
Views
Topic starter
hi all
can somebody help me with this,
i want to combine the two formula into one formula... this formula calculate forex pips, but there are 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 write 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
Posted : 27/03/2020 4:25 pm
Hi Mohamed,
No file is attached.
Regards
Phil
Posted : 27/03/2020 9:07 pm
