Formula ? Not understanding why its returning 1,000 instead of a 100,000

[zone709]

Hi the P&L is returning 2,000 but I think it should be returning 200,000. Trying to figure out why its not. This is the formula I'm using under the P&L CELL =(M12-H12)*G12*10

<colgroup><col width="92" style="width:69pt"> </colgroup><tbody>
</tbody>

Excel 2016 (Windows) 32 bit

	F​	G​	H​	I​	J​	K​	L​	M​
7​	​	​	​	N​	​	​	​	​
8​	​	​	​	POSITION​	P&L​	​	​	​
9​	​	​	​	0 ​	$2,000 ​	​	​	​
10​	​	​	​	​	​	​	​	​
11​		N​	BUYS​	​	​	​	N​	SALES​
12​		100​	52.00​	​	​	​	100​	54.00​
13​		QUANITY​	PRICE​	​	​	​	QUANITY​	PRICE​
14​	INITIAL POSITION	0​	0​	0​	​	INITIAL POSITION	0​	0​

Sheet: Flat Price

 

[Jonmo1]

I think OP wants the formula to return 200000 whether he enters 52 or 5200


I think you would be best off applying some consistency to your sheet.
Pick one or the other.

 

[zone709]

Yes I did thanks