If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel functions help
Hi Sothear!
In all cases the formula you want goes in you "TO column. So the first requirement involves a formula in column P Example of column P formula =IF(J1="A",F1,"") Second: Example of column N formula =IF(J1="O",F1,"") Third: Example of column M formula =IF(J1="P",F1,"") I've assumed that where the conditions are not met you want to return a "" (making the cell *look" empty) -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Sothear" wrote in message ... I'd like to achive an excel functions of the following scenario: Column F (value), Column J (Code) A,O,and P, Column M, Column N, Column P - If Column J with code "A", return value in column "F" TO column "P" - If column J with code "O", return value in column "F" TO column "N" - If column J with code "P", return value in column "F" TO column "M" Thanks Sothear |
#2
|
|||
|
|||
Excel functions help
Sothear,
You should use three functions to do that: In P1 place =IF(J1="A",F1,"") In N1 place =IF(J1="O",F1,"") In M1 place =IF(J1="P",F1,"") Then copy down the three formulas as far as you got data in columns F and J. Kind regards, Marcel Kreijne Quandan - Steunpunt voor spreadsheetgebruikers (Quandan - dutch supportsite for spreadsheetusers) www.quandan.nl "Sothear" schreef in bericht ... I'd like to achive an excel functions of the following scenario: Column F (value), Column J (Code) A,O,and P, Column M, Column N, Column P - If Column J with code "A", return value in column "F" TO column "P" - If column J with code "O", return value in column "F" TO column "N" - If column J with code "P", return value in column "F" TO column "M" Thanks Sothear |
#3
|
|||
|
|||
Excel functions help...addtional help
Hello Norman, Additional help... I'd like to able to type in code: A or O or P in column J, and value in column F would shift to each destination column automatically? Thanks Sothear ----- Norman Harker wrote: ----- Hi Sothear! In all cases the formula you want goes in you "TO column. So the first requirement involves a formula in column P Example of column P formula =IF(J1="A",F1,"") Second: Example of column N formula =IF(J1="O",F1,"") Third: Example of column M formula =IF(J1="P",F1,"") I've assumed that where the conditions are not met you want to return a "" (making the cell *look" empty) -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Sothear" wrote in message ... I'd like to achive an excel functions of the following scenario: Column F (value), Column J (Code) A,O,and P, Column M, Column N, Column P - If Column J with code "A", return value in column "F" TO column "P" - If column J with code "O", return value in column "F" TO column "N" - If column J with code "P", return value in column "F" TO column "M" Thanks Sothear |
Thread Tools | |
Display Modes | |
|
|