I need microsoft excel help in math?

I’m taking this class in college I need to know how to make excel do a certain task.

I want a specific cell equal a certain number, when I add to numbers in I want that number equal to the cell without going over or under. No matter the numbers enter I want the program to enter numbers that will equal my total. My first exam depends on it.

If there is any geniuses out there in this please help!

---

Answer:
Use A1 to enter a number. Assume your total is 25. Then in B1, enter the formula: 25-A1

So if you enter 20 in A1, B1 should display 5. That what you want?

---

Answer:
See Excel Help for IF

---

Answer:
Ever thing you need to know. go to www.mrexcel.com This guy is an expert on excel.do a search,you will not believe how much info there is.

---

Answer:
I'm not sure I understand the question, so you may need to post the way it is worded on your exam if this isn't what you are looking for.

If you are looking for a way to generate and add random numbers to equal a third number that is pre-determined, you can use the RAND() function.

Cell 1 =Cell3*RAND()

Cell 2 =(1-Cell1)

Cell 3 =Your Predetermined Number

Book Mark it-> del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Netscape | Yahoo | BlinkList

Tags: excel, help, math, Microsoft, need