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]

 

[peterhinton]

= (54-52) * 100 * 10 = 2000

 

[Rick Rothstein]

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




Excel 2016 (Windows) 32 bit
[TABLE="class: head"]
<tbody>[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]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Flat Price[/TD]
[/TR]
</tbody>[/TABLE]

Looks right to me... (M12-H120) = (54-52) = 2... 2*g12 = 2*100 = 200... 200*10 = 2000

 

[Jonmo1]

How would it be 200000 ?

Let's plug in the numbers.
=(M12-H12)*G12*10

M12 = 54
H12 = 52

=(54-52)*G12*10

54-2 = 2

=(2)*G12*10
=2*G12*10

G12 = 100
=2*100*10

2*100 = 200
=200*10

=2000

 

[Norie]

Why do you expect 200,000?

=(M12-H12)*G12*10 => (54-52)*100*10 => 2,000

 

[Scott T]

I think you want to multiply by 1000
(54-52)*100*1000=200,000

 

[zone709]

wait guys lol. I think I know why. I am pricing it as 5200 and 5400. so subtract that it would be 200*10 etcc that will give me 200,000

 

[zone709]

Yes Scott I can either do this 5200 or multiply by the thousands

 

[zone709]

ok so I have a question is there a way to do this math if I change this formula =(M12-H12)*G12*10. So if I type in the cells 52 or 52.00 or 5200 that it will pick it up by the hundredth then by jus 2?

 

[Rick Rothstein]

ok so I have a question is there a way to do this math if I change this formula =(M12-H12)*G12*10. So if I type in the cells 52 or 52.00 or 5200 that it will pick it up by the hundredth then by jus 2?

I cannot figure out what you are asking for here... perhaps some before and after examples would help.