Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logical functions IF & AND
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,A 2) If you need more explanation or clarity of information, let me know. Any input is appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logical functions IF & AND
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 Sam wrote: 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! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logical functions IF & AND
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. "edvwvw via OfficeKB.com" wrote: 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 Sam wrote: 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! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logical Functions | Excel Worksheet Functions | |||
Logical Functions | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions | |||
using logical functions | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions |