Cells equal a number

  • Thread starter Thread starter DR
  • Start date Start date
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.
 
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.
 
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.
 
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
 
Back
Top