# percentage

#### greenberret1960

##### New Member
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

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### mole999

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

#### greenberret1960

##### New Member
 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

##### New Member
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

##### Moderator

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

##### New Member
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

Last edited:

#### greenberret1960

##### New Member
thank you very much for your time i think i got it

Replies
0
Views
82
Replies
2
Views
98
Replies
7
Views
269
Replies
0
Views
235
Replies
1
Views
29

1,128,122
Messages
5,628,818
Members
416,342
Latest member
BlueDevil12

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back