Logical functions IF & AND

[Sam]

This is what I have:
Columns A/B/C/D/...
Last Name/First Name/Social Security Number/Time Worked/...

Some employees have multiple entries to track multiple times they have
worked for the firm. I have a summary entry for the total time worked, but I
entered it as follows.

[blank]/[blank]/[blank]/100 (summation of time worked listed below)
Doe/John/xxx-xx-xxxx/50
Doe/John/xxx-xx-xxxx/50

I need the [blank] entries to be filled in by the proceeding rows. In the
end, I want every row to have Last Name/First Name/SSN. Some of the
employees have only one row, or entry. In that case, I want to leave the
cell unchanged. The formula I've tried using is:
=IF(AND(ISBLANK(A2),(ISBLANK(B2),iSBLANK(C2)),A3,A2)

If you need more explanation or clarity of information, let me know. Any
input is appreciated!

 

[edvwvw via OfficeKB.com]

Say the [blank ] entries are in the row above - you will get a circular error
if you include the cell that the formula references: for example in cell A1

=IF(ISBLANK(A1),A2,A1) - checks whether A1 is blank, if so copies cell A2 if
not blank does nothing.

Better that the [blank] row is beneath and then you can pickup the rows that
you want to copy and use the fill handle to copy the relevant data.

Hope that helps

edvwvw

This is what I have:
Columns A/B/C/D/...
Last Name/First Name/Social Security Number/Time Worked/...

Some employees have multiple entries to track multiple times they have
worked for the firm. I have a summary entry for the total time worked, but I
entered it as follows.

[blank]/[blank]/[blank]/100 (summation of time worked listed below)
Doe/John/xxx-xx-xxxx/50
Doe/John/xxx-xx-xxxx/50

I need the [blank] entries to be filled in by the proceeding rows. In the
end, I want every row to have Last Name/First Name/SSN. Some of the
employees have only one row, or entry. In that case, I want to leave the
cell unchanged. The formula I've tried using is:
=IF(AND(ISBLANK(A2),(ISBLANK(B2),iSBLANK(C2)),A3,A2)

If you need more explanation or clarity of information, let me know. Any
input is appreciated!

 

[Sam]

I understand your suggestion, but it cannot work for this situation. When I
use the fill handles to copy the data, the SSN automatically advances by one.
Therefore, the only solution I see is actual copy and paste. It is a
painstaking process, but it might be the only choice I've got at this point.

Thanks for the reply.

Say the [blank ] entries are in the row above - you will get a circular error
if you include the cell that the formula references: for example in cell A1

=IF(ISBLANK(A1),A2,A1) - checks whether A1 is blank, if so copies cell A2 if
not blank does nothing.

Better that the [blank] row is beneath and then you can pickup the rows that
you want to copy and use the fill handle to copy the relevant data.

Hope that helps

edvwvw

This is what I have:
Columns A/B/C/D/...
Last Name/First Name/Social Security Number/Time Worked/...

Some employees have multiple entries to track multiple times they have
worked for the firm. I have a summary entry for the total time worked, but I
entered it as follows.

[blank]/[blank]/[blank]/100 (summation of time worked listed below)
Doe/John/xxx-xx-xxxx/50
Doe/John/xxx-xx-xxxx/50

I need the [blank] entries to be filled in by the proceeding rows. In the
end, I want every row to have Last Name/First Name/SSN. Some of the
employees have only one row, or entry. In that case, I want to leave the
cell unchanged. The formula I've tried using is:
=IF(AND(ISBLANK(A2),(ISBLANK(B2),iSBLANK(C2)),A3,A2)

If you need more explanation or clarity of information, let me know. Any
input is appreciated!