Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
mutiple if formulas
how do i create a formula in sheet2 with converted data from sheet1 in one
column. i want formula in sheet2 to say. if sheet1 column A is "issue" then put "i", if it's "days" put "d", if it's "frank" put "f" sheet1 A 1 issue 2 days 3 frank 4 apple hope that make sense |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
mutiple if formulas
Try this in A1 of Sheet2:
=IF(Sheet1!A1="","",LEFT(Sheet1!A1,1)) Copy down as required. Hope this helps. Pete On Jun 18, 1:39*am, JaneSmith wrote: how do i create a formula in sheet2 with converted data from sheet1 in one column. i want formula in sheet2 to say. if sheet1 column A is "issue" then put "i", if it's "days" put "d", if it's "frank" put "f" sheet1 * A 1 issue 2 days 3 frank 4 apple hope that make sense |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mutiple COUNTIF or equivalent. | Excel Worksheet Functions | |||
Vlookup on mutiple worksheets | Excel Discussion (Misc queries) | |||
Mutiple Excel Windows. | Excel Discussion (Misc queries) | |||
can i.. do a COUNT through mutiple worksheets? | Excel Discussion (Misc queries) | |||
mutiple regression help | Excel Discussion (Misc queries) |