I'm cluesless - need help with "functions"?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mandi - 25 Mar 2008 15:23 GMT

I'm trying to transcribe information from timecards to a spreadsheet. The
person who designed the spreadsheet for me only put in equations to row 46
(not nearly enough). Heres an idea of what it looks like since I am too
uneducated on this program to know how to describe it. Cell A4 looks like
this : =IF(B3="","",B3)
A46 says, =IF(B45="","",B45). My question is: Is there a way to just
automatically put the next line's equation in, or do I have to type it all
out? Seems to me that would just double my work load. (i.e. A46 says
=IF(B45="","",B45) I want A47 to automatically say =IF(B46="","",B46)) Is
there a way to make that happen? He also set it up so that when I typed in a
date (i.e. 1/3) it would convert it into the day of the week in the next
column - is there a way to continue that on down the page? Ack!! I think
I'm even more confused now than I was 10 minutes ago. Please help. Thanks
so much in advance.

Reply to this Message

Nick - 25 Mar 2008 15:28 GMT

Hi Mandi,
If you click on the cell you want you will see it gets highlighted in bold
and there is a little box in the bottom right corner. if you drag this box
into your next cell it should copy the formula and format over onto the next
cell.

Hope this helps

Nick, Scotland

> I'm trying to transcribe information from timecards to a spreadsheet. The
> person who designed the spreadsheet for me only put in equations to row 46
[quoted text clipped - 10 lines]
> I'm even more confused now than I was 10 minutes ago. Please help. Thanks
> so much in advance.

Reply to this Message

Mandi - 25 Mar 2008 18:37 GMT

First let me thank you for responding. Maybe I didn't fully understand what
was being explained.
I clicked on the last cell to have been formatted, grabbed the little
black square, and drug it down as far as I wanted. I repeated that for all
the columns I needed extended further down the page, but none of it is having
an effect. The cells had a black outline afterward, but that was the only
noticeable difference. I need for it to understand that B47 - A47 = F47,
that when I type in 1/30 in D47, that E47 needs to say Wed. , and finally,
for the time in B47 to be copied into A48.

> Hi Mandi,
> If you click on the cell you want you will see it gets highlighted in bold
[quoted text clipped - 20 lines]
> > I'm even more confused now than I was 10 minutes ago. Please help. Thanks
> > so much in advance.

Reply to this Message

Nick - 25 Mar 2008 15:30 GMT

Just to make it clearer. when u put cursor over box ur cursor will turn to a
+ sign. now click and drab into as many cells as you need

Reply to this Message

Max - 25 Mar 2008 15:33 GMT

> A46 says, =IF(B45="","",B45)

Just drag the fill handle* of cell A46 down as far as required, to fill the
formula in advance of expected data. The formula will auto-increment as
desired, and the formula cells will appear "blank" until data is entered in
col B.
*that's the solid black square at the bottom right corner of the cell

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

Gord Dibben - 25 Mar 2008 19:27 GMT

In addition, make sure you have Tools>Options>Calculation set to "Automatic"

Gord Dibben MS Excel MVP

>> A46 says, =IF(B45="","",B45)
>Just drag the fill handle* of cell A46 down as far as required, to fill the
>formula in advance of expected data. The formula will auto-increment as
>desired, and the formula cells will appear "blank" until data is entered in
>col B.
>*that's the solid black square at the bottom right corner of the cell

Reply to this Message

Rate this thread: