[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

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

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
Rowby Goren
Asked:
Rowby Goren
  • 8
  • 4
2 Solutions
 
nutschCommented:
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
 
helpfinderCommented:
probably you are asking for something like this (attachment)
10-percent.xlsx
0
 
Rowby GorenAuthor Commented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
helpfinderCommented:
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
 
Rowby GorenAuthor Commented:
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
 
helpfinderCommented:
so how was the MS Publisher import?
0
 
Rowby GorenAuthor Commented:
Hi

I'm doing the import now.  Stay tunec!
0
 
Rowby GorenAuthor Commented:
Hi Helpfinder:  

Any reason why your formula was

=A2*0.9

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

Rowby
0
 
Rowby GorenAuthor Commented:
One final question.  

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

Example:  

Instead of  $1,490.00

I want the cell to display

 $1,490

Thanks!

Rowby
0
 
Rowby GorenAuthor Commented:
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
 
Rowby GorenAuthor Commented:
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
 
helpfinderCommented:
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
 
Rowby GorenAuthor Commented:
Thanks  nutsch and helpfinder.  It might have been a simple question, but your solutions took care of the issue!

Rowby
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 8
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now