percentage

[greenberret1960]

how can i get one cell to show the number in percentage please i trade the forex market and the numbers vary by currency pair

 

[mole999]

where do you draw your two values from. I.e the whole and the smaller slice

 

[greenberret1960]

1.05643	1.04129	0.01514
close	low
1.06525	1.04129	0.02396
high	low
0.01514	0.02396	63%

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[greenberret1960]

close minus the low 0.01514
high minus the low 0.02396

0.01514 divided by 0.02396 =0.6318864774624 thus 63% am i correct

 

[mole999]

ADVERTISEMENT

i did this to check

A1 = 10, B1 - 1, that has to be 10% as =B1/A1
I plugged your numbers in the way you said them
A2 0.01514, B2 0.02369 and dragged the formula down which provides me with 632% seems wrong to me, I'd have to play with it a bit

 

[greenberret1960]

any help would be greatly appreciated thank you for your time with this i am sure you excel wizards are very busy helping idiots like me by the way the first 2 numbers are whole numbers the last is fractional i have a pdf format 4 page summary if that would help you i can e-mail it to you that explains it all

 

[mole999]

this explains it better than I can. I always test against what I think I should get from something easy then move to the actual values to be manipulated > https://www.ablebits.com/office-addins-blog/2015/01/14/calculate-percentage-excel-formula/

 

[greenberret1960]

thank you very much for your time i think i got it