Risk reward in Forex

%3CLINGO-SUB%20id%3D%22lingo-sub-2057063%22%20slang%3D%22en-US%22%3ERisk%20reward%20in%20Forex%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2057063%22%20slang%3D%22en-US%22%3E%3CP%3EFound%20a%20video%20on%20YT%20where%20this%20formula%3A%26nbsp%3B%3CSPAN%3E%3DIF(E5%3D%22%22%2C%22%22%2CIF(C5%3D%22LONG%22%2C(G5-E5)%2F(E5-F5)%2C(E5-G5)%2F(F5-E5)))%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EWas%20written%20in%20excel%20to%20calculate%20risk%20and%20reward%20ratio%20in%20forex%20trading.%20It%20dosent%20work%2C%20and%20i%20really%20dont%20know%20why%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2057063%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2057106%22%20slang%3D%22en-US%22%3ERe%3A%20Risk%20reward%20in%20Forex%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2057106%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F927815%22%20target%3D%22_blank%22%3E%40Ratheepan%3C%2FA%3E%26nbsp%3BTry%20replacing%20the%20commas%20with%20semi-colons.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2057176%22%20slang%3D%22en-US%22%3ERe%3A%20Risk%20reward%20in%20Forex%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2057176%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you%20soo%20much!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Found a video on YT where this formula: =IF(E5="","",IF(C5="LONG",(G5-E5)/(E5-F5),(E5-G5)/(F5-E5))) 

Was written in excel to calculate risk and reward ratio in forex trading. It dosent work, and i really dont know why  

3 Replies

@Ratheepan Try replacing the commas with semi-colons.

@Riny_van_Eekelen Thank you soo much!!

You're welcome!