Ask Your Question

In calc, how do i add number and percentage in the same cell ?

asked 2018-10-20 07:20:57 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

For example if in cell A1, I have entered 200 and in cell A2, I have entered 20, I want a display in cell A2 as 20(10%) to be calculated on its own.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-20 08:48:17 +0200

ebot gravatar image

That does not work like this. The cell contains either a value or a formula.

Either the value is included in the formula. image description

Or the value is in a cell and the formula is separate. image description

edit flag offensive delete link more


As @ebot has explained, you can't do that in a spreadsheet. The concept of a spreadsheet is based on each cell containing a single "value", each value being either a string of text, or a number, or a formula for calculating a number. What you want to do might be possible by devising a macro (a script that performs a series of steps) which would produce a string of text containing both the given number and the calculated number that you want. Complicated and no guarantees!

ve3oat gravatar imageve3oat ( 2018-10-22 21:48:43 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-20 07:20:57 +0200

Seen: 57 times

Last updated: Oct 20 '18