need to enter a numerical value in one cell, enter a % figure in the next cell and return the value in the cell next to that,

ie
cell 1, cell2, cell 3
£150, 10%, £15

normally i can do this myself but cant find the formula i need to write this all in one cell..

ta

i dunno if this is what u need but in the 3rd cell, if u type =A1/100*B1 then u'll have the value of the 3rd cell

where: A1 = value of 1st cell
and B1 = value of 2nd cell (percent)

Or

A1 enter 150
B1 enter 10
C1 enter A1/B1

derrr a1/b1 was what i was after,, think i was over complicating it..... ta

[quote name='Kremmen' post='359151' date='Jun 12 2006, 06:49 AM']Or

A1 enter 150
B1 enter 10
C1 enter A1/B1[/quote]

That's not quite right as if you needed 50%, and put 150/50 you get 3 and not 75.

For the formula..

A1 - £150
A2 - 100
A3 - The percent you want to calculate ie 10 in this case
A4 - =A1*(A3/A2)

Remember to type the equals sign..

The easiest way however is to put

A1 - £150
A2 - Percent you want to calculate
A3 - =A1*A2

But, select Cell A2 and then on the formatting bar at the top of the worksheet, click on the % button.

[quote name='Fargo' post='359153' date='Jun 12 2006, 07:17 AM']derrr a1/b1 was what i was after,, think i was over complicating it..... ta[/quote]

no probs

thanks rich bee,, i was just coming to that, after entering a differnt % to work out lol..