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[TABLE="width: 92"]
<colgroup><col width="92" style="width:69pt"> </colgroup><tbody>[TR]
[TD="width: 92, bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]




Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][th]

L​

[/th][th]

M​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

7​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

N​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

8​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

POSITION​

[/td][td]

P&L​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

9​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

0 ​

[/td][td]

$2,000 ​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

10​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

11​

[/td][td][/td][td]

N​

[/td][td]

BUYS​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

N​

[/td][td]

SALES​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

12​

[/td][td][/td][td]

100​

[/td][td]

52.00​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

100​

[/td][td]

54.00​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

13​

[/td][td][/td][td]

QUANITY​

[/td][td]

PRICE​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

QUANITY​

[/td][td]

PRICE​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

14​

[/td][td=bgcolor:#D0CECE]INITIAL POSITION[/td][td=bgcolor:#D0CECE]

0​

[/td][td=bgcolor:#D0CECE]

0​

[/td][td]

0​

[/td][td]

​

[/td][td=bgcolor:#D0CECE]INITIAL POSITION[/td][td=bgcolor:#D0CECE]

0​

[/td][td=bgcolor:#D0CECE]

0​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Flat Price[/td][/tr][/table]

 

[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