topic Re: working with percentages in cells sums in AutoCAD Forum

working with percentages in cells sums

sscott1664 — Mon, 19 Feb 2024 12:49:59 GMT

Hi I'm new to working with tables and I cannot figure out how to work out a certain sum, I need one cell that can be changed in value from 0 to 100 this is the percentage cell (A) , In the second cell I need a value from 0 to 100 again (B).

The sum will be in a third cell and i need it to calculate (A) + (B) = (total)

(A) (B) (C)

25% 100 = 125

33% 90 = 119.7

10% 45 = 49.5

if you get my drift, if you could help with the formula for the above that would be great. Thanks You.

Re: working with percentages in cells sums

parkr4st — Mon, 19 Feb 2024 14:57:22 GMT

=Sum(A2:B2) for example

Re: working with percentages in cells sums

paullimapa — Mon, 19 Feb 2024 16:26:28 GMT

Sounds like you want to multiply A and B then add that result with B to get C?

Re: working with percentages in cells sums

sscott1664 — Mon, 19 Feb 2024 16:50:37 GMT

I have figured out the formula i need its =(B3/B2)*100+B2 thank you for your replies