# Find what is the number, that will make 2 cells ABS equal

Closed
Report

albertask

yg_be

- Posts
- 3
- Registration date
- Saturday December 24, 2016
- Status
- Member
- Last seen
- December 25, 2016

yg_be

- Posts
- 17787
- Registration date
- Sunday June 8, 2008
- Status
- Contributor
- Last seen
- December 8, 2021

Related:

- Find what is the number, that will make 2 cells ABS equal
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
- Care code: 205.2 [lu003] - Forum - Yahoo Mail
- Excel if cell contains date then return value ✓ - Forum - Office Software
- How to recover deleted emails from gmail after 2 years ✓ - Forum - Google
- How to only have 2 best friends on snapchat - Guide

## 1 reply

yg_be

- Posts
- 17787
- Registration date
- Sunday June 8, 2008
- Status
- Contributor
- Last seen
- December 8, 2021

Hi.

You did not attach any file, you just attached a picture.

Do you know how to manually compute the Break Even point? Are you asking assistance about computing it, or about writing a formula to achieve that computation?

Do you mean that you want a formula returning the value of "1" causing "2"+"3"=0?

You did not attach any file, you just attached a picture.

Do you know how to manually compute the Break Even point? Are you asking assistance about computing it, or about writing a formula to achieve that computation?

Do you mean that you want a formula returning the value of "1" causing "2"+"3"=0?

Thanks for the reply.

I can't attach an excel sheet.

about Break Even point... I want a formula that will calculate and return me the asset value\price which will balance lose and profit.

I need a formula to put in a cell that will calculate this break even point.

For example: Current price is : 1.2600. We trade GBP/USD low.

if the entrance point of the first was 1.2360, each pip value is 16.22$. I'm in a loss of 3892.80$.

and the entrance of the second is 1.2700, and in this trade only the pip value is 32.44$. I'm in a profit on this trade 3244$.

In total i'm in a loss of 648.8$.

Break even point for this example is 1.25866666666667.

Don't forget that on every move in your trade direction (LOW in this example) there is a change in the loss of the first trade and a change in the profit of the second one.

It is easy to share an excel file : you simply publish it, and you share the link on this forum.