Do Not Sell My Personal Information Jump to content


Excel Formula Help Please


Fargo
 Share

Recommended Posts

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

Link to comment
Share on other sites


Or

A1 enter 150

B1 enter 10

C1 enter A1/B1

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share





×
×
  • Create New...




Forums


News


Membership