help!!!

  • Thread starter Thread starter Fernandokim
  • Start date Start date
F

Fernandokim

i'm trying to build a budget and i need help.........can someone tell me how
can i put a fix number into a cell of a number that i don;t know yet.... for
example
I want to allocate 100 into food out of my income cell (B12), but because my
income change week to week i will not know how much it is until pay
day........so what i want to put in the food cell is...."100 of B12, so
whenever i put the amount on B12 cell 100 will go to food cell
 
Enter this formula in your "food cell" :

=IF(B12="","",100)

The food cell will remain blank until you enter something in cell B12. I'm
assuming that all you'll enter into cell B12 is a number.
 

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

Similar Threads

Making a budget with excel, keep a running total 1
Array Function to do a Sum of VLookUps that translate a letter gra 3
Keep the first cell when summing a column? 1
Don't want to plot blank cells on my chart 4
Comparing cell contents, know cell address 4
Formula to replace a Pivot table function 4
IF Statement 4
IF Formula Porblems 1

Back
Top