Solved

Excel Formula for making one cell to be 10% of another cell -- then making that new data permanent

Posted on 2012-08-22
282 Views
Hi

I know little about Excel, and less about formulas.  But this is certainly simple!

I have several cells.

Let's say cell "A" is \$150.
I want cell "B" to be 10% of Cell "A".

What is the formula to make that happen.

Then, once the cell "B" has that data, I want it to be permanent so that I can export the spreadsheet into another application.

Thanks!

Rowby
0
Question by:Rowby Goren

LVL 39

Accepted Solution

formula would be =10%*A1
then you copy that cell (Ctrl+C) and do a paste values (if you're in excel 2007+, go to the home tab, paste button and choose values)

You could do this automatically but it would require a macro.

Thomas
0

LVL 19

Expert Comment

probably you are asking for something like this (attachment)
10-percent.xlsx
0

LVL 9

Author Comment

Hi helpfinder.

Yes.  That's exactly what I want.

And I see your formula.

Do I need to do anything to make column "B" permanent so that I can save the spreadsheet and then export it into another application?

Thanks

Rowby
0

LVL 19

Expert Comment

column B is permanent, I mean if you enter new values into A column and extend B column formula you always get 10% less value.
If you mean permanent like to block B column for editing it is possible to do this.
export to another application with values you see should not be a problem (but might depend on application you are importin to)
0

LVL 9

Author Comment

Sounds good.  I'll be importing it into Microsoft Publisher.

As soon  as I am able to successfully to that (and I am sure I will have no problems) I'll award you the points.

Give me at least until tomorrow.

Thanks for helping me so quickly!

Rowby
0

LVL 19

Expert Comment

so how was the MS Publisher import?
0

LVL 9

Author Comment

Hi

I'm doing the import now.  Stay tunec!
0

LVL 9

Author Comment

Hi Helpfinder:

Any reason why your formula was

=A2*0.9

instead of something that looks more like 10?  (to be 10%)

Rowby
0

LVL 9

Author Comment

One final question.

How do I format a Currency cell NOT to include the "cents".

Example:

I want the cell to display

\$1,490

Thanks!

Rowby
0

LVL 9

Author Comment

Just double checked, and it appears that the forumula is creating 90%.

I want it to be 10%

Am I right or confused:

=A2*0.9
0

LVL 9

Author Comment

Hee heee

I made the obvious fix:

=B2*0.1

I assume the above formula is now 10%

Duh!

Let me know, for sure though.

Thanks

Rowby
0

LVL 19

Assisted Solution

Yes, if you want to see 10% of the value you have to multiply cell*0,1 (if there is cell*0,9 then you cut 10% and see the 90% of the original value)
Regarding your currency question, right click on the cell > format cells ... > on Number tab check Currency category and in right pane set 0 for decimal places
decimal.PNG
0

LVL 9

Author Closing Comment

Thanks  nutsch and helpfinder.  It might have been a simple question, but your solutions took care of the issue!

Rowby
0

Write Comment

Please enter a first name

Please enter a last name

We will never share this with anyone.

Featured Post

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!