Cells equal a number


D

DR

How do I require (in Excel 2000) A1 + A2 + A3 to equal 100 and then allow
entries to be made and revised? Thanks.
 
Ad

Advertisements

N

Norman Harker

Hi DR!

Try using Goal Seek is one way.

But you might do it by using a formula:

eg
A3:
=100-(A1+A2)
Will return the value in A3 that causes A1+A2+A3 to equal 100

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
D

DR

No, I must be able to allow entries to be made and revised, e.g., enter 30,
30, and 40, then change A3 to 50 and A1 and A2 change to 25.
 
Ad

Advertisements

F

Frank Kabel

Hi
not really possible within cells as you don't know at which point you
should check the values if you want to change them. As any change would
leed to a wrong result.
some workaround ideas:
- use a userform for this and do the checking if the user clicks on the
o.k button
- use a separate cell which issues a warning message if the Sum is not
equal to 100 (add a conditional format to this)
- use a check in your workbook_beforesave event to ensure that only
valid entries are saved
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top