formula to enter data into a blank cell

N

NateM

Does anyone know of a formula that will put a value into a blank cell? So far
it seems that all of excels formulas look at values and conditions of a cell.
It seems none put a value into a blank cell.

Background for the question:
I've created a calendar to track vacation time spent in a given year using
excel. Each day of the calendar is made up of 2 cells (one on top of the
other). The top cell for the day contains the date. The bottom cell the user
will enter either a 'V' for vacation or 'S' for sick time.
So far I have the calendar setup so that when I change the year excel will
automatically change the calendar's days and dates to make them accuate for
the given year.
I want to add a piece that will fill the bottom cells with an 'H' for the
company "approved" holidays. I know I could put a formula into all the cells
of the calendar that would check the date against a list of Holidays and fill
the cell with an 'H'. The problem is I need the bottom cells to be blank so
that the users know those cells are for data enty.
 

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