Blank cell cant make calculations !

TheSardOz

New Member
Joined
Nov 30, 2020
Messages
26
Office Version
  1. 365
Platform
  1. Windows
Hello Forum!
I have this data and I would like to calculate the profit loss,( entry value - exit value) or the other way around it depend if is a long or a short.
The problem I am facing is that I can't make the calculation because the data in not linear but shifted, what's the best solution ?


Thank you !


1606822232502.png
 
hi ThesardOz,
From your last results, it seems the conditional part of the formula needs some amendments. I'd suggest evaluating formula steps with matching conditions using the [F9] key and then changing the matching criteria, if needed.
Initially the formula was designed to compute results based on a single group, CODE, and then matches the criteria of Long/Short etc., e.g. if you had 4 rows of code DOC then the computations were made starting from 1st occurrence of DOC till the last one, keeping in view Long/Short. But now, maybe, I think you are computing the results for 2 rows, I m sorry but I have no experience in trading therefore, it might be getting way over my head.

I hope my explanation makes sense.
Thank you very much for taking your time to help!
 
Upvote 0

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top