Formula to calculate profit/lost

[Maurizio]

Hi all,
with this data, what is the formula for profit/lost?

Name	Amount	Unit	EntryPrice	MarketPrice	Profit/Lost
AVGO-USD	$41.51	1	207.55	207.92	2.87
NVDA-USD	$48.172	2	120.43	126.06	3.63
TM-USD	$37.372	1	186.86	187.55	2.89
NIO-USD	$50.64	60	4.16	4.2	2.40

Tia.

 

[StephenCrump]

Are the numbers in the Profit/Lost column the results you're expecting to see?

How are you calculating these?

 

[Maurizio]

Yes, but I can't get the result with any formula (if it exists).
It seems to me that something is not correct ?!

 

[Maurizio]

only about:

NIO-USD

$50.64

60

4.16

4.2

2.40

I get (60x4.20)-(60x4.16)=2.40

 

[StephenCrump]

It seems to me that something is not correct ?!

I'm not sure we can help any further without understanding how the results were calculated.

But it's not clear to me how the first three results below were calculated (nor how the 4th result relates to the "Amount" of 50.64).

Where did the data come from, and what does it represent?

	A	B	C	D	E	F	G
1	Name	Amount	Unit	EntryPrice	MarketPrice	Profit/Loss	Formula?
2	AVGO-USD	41.51	1	207.55	207.92	2.87
3	NVDA-USD	48.17	2	120.43	126.06	3.63
4	TM-USD	37.37	1	186.86	187.55	2.89
5	NIO-USD	50.64	60	4.16	4.20	2.40	2.40
Sheet1

Cell Formulas
Range	Formula
G5	G5	=C5*(E5-D5)

 

[Maurizio]

I'm not sure we can help any further without understanding how the results were calculated.

But it's not clear to me how the first three results below were calculated (nor how the 4th result relates to the "Amount" of 50.64).

Where did the data come from, and what does it represent?

	A	B	C	D	E	F	G
1	Name	Amount	Unit	EntryPrice	MarketPrice	Profit/Loss	Formula?
2	AVGO-USD	41.51	1	207.55	207.92	2.87
3	NVDA-USD	48.17	2	120.43	126.06	3.63
4	TM-USD	37.37	1	186.86	187.55	2.89
5	NIO-USD	50.64	60	4.16	4.20	2.40	2.40
Sheet1

Cell Formulas
Range	Formula
G5	G5	=C5*(E5-D5)

Thanks, you're right! the final calculations of the first 3 values are incorrect.
Tia.