asked on

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

ASKER CERTIFIED SOLUTION

nutsch

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

helpfinder

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

Rowby Goren

ASKER

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

helpfinder

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)

Rowby Goren

ASKER

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

helpfinder

so how was the MS Publisher import?

Rowby Goren

ASKER

Hi

I'm doing the import now. Stay tunec!

Rowby Goren

ASKER

Hi Helpfinder:

Any reason why your formula was

=A2*0.9

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

Rowby

Rowby Goren

ASKER

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

Rowby Goren

ASKER

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

Rowby Goren

ASKER

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

SOLUTION

helpfinder

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rowby Goren

ASKER

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

Rowby