Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Functions (IF)
I want to create a worksheet in Excel 2003 that does something like...
=IF('Underground & Kits'!D4 0, 'Underground & Kits'!B4:F4', 0 Where if a quantitiy is entered for a line item, then it will return the line item, price, and quantity. -which are about 4 cells in a row that I want to carry over into this worksheet. I need this to work not just to carry over data from one page, but many. I also need to hide cells if blank or Zero once i have this put together. When I use the above formula, it keeps returning an error message and I am not sure how to get what I want. Any help will be greatly appreciated! -- Melissa |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Functions (IF)
You can't fit more than one cell into another cell so in your example you
can't fit B4:F4 into a single cell. You can do something like: =IF('Underground & Kits'!$D4 0, 'Underground & Kits'!B4', 0) and drag it (copy/paste) to multiple locations. As for hiding rows, you can either right click on the row (on the far left on the number) or you can run a quick macro that will check if the row has anything in it and if it doesn't, it can hide it for you. If you are doing this on a regular basis, I would consider looking in to writing a macro (or getting one from these forums). I hope this helps! Let me know if this doesn't answer your question. -- -SA "Melissa" wrote: I want to create a worksheet in Excel 2003 that does something like... =IF('Underground & Kits'!D4 0, 'Underground & Kits'!B4:F4', 0 Where if a quantitiy is entered for a line item, then it will return the line item, price, and quantity. -which are about 4 cells in a row that I want to carry over into this worksheet. I need this to work not just to carry over data from one page, but many. I also need to hide cells if blank or Zero once i have this put together. When I use the above formula, it keeps returning an error message and I am not sure how to get what I want. Any help will be greatly appreciated! -- Melissa |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Functions (IF)
On Jul 21, 12:08 pm, StumpedAgain
wrote: You can't fit more than one cell into another cell so in your example you can't fit B4:F4 into a single cell. You can do something like: =IF('Underground & Kits'!$D4 0, 'Underground & Kits'!B4', 0) and drag it (copy/paste) to multiple locations. As for hiding rows, you can either right click on the row (on the far left on the number) or you can run a quick macro that will check if the row has anything in it and if it doesn't, it can hide it for you. If you are doing this on a regular basis, I would consider looking in to writing a macro (or getting one from these forums). I hope this helps! Let me know if this doesn't answer your question. -- -SA Perhaps this instead: =IF(OR('Underground & Kits'!$D4="",'Underground & Kits'! $D4=0),"",'Underground & Kits'!B4') |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Functions (IF)
Melissa:
if(cellref0,"Line Item = " & vlookup(itemnumber,rangeofitems,column_num_LineIte m)&" Price = $"&vlookup(itemnumber,rangeofitems,column_num_pric e)&" etc.... ",0) or, you could put each if, vlookup, combination into a seperate cell, rather than concatenating the answer together.... "Melissa" wrote: I want to create a worksheet in Excel 2003 that does something like... =IF('Underground & Kits'!D4 0, 'Underground & Kits'!B4:F4', 0 Where if a quantitiy is entered for a line item, then it will return the line item, price, and quantity. -which are about 4 cells in a row that I want to carry over into this worksheet. I need this to work not just to carry over data from one page, but many. I also need to hide cells if blank or Zero once i have this put together. When I use the above formula, it keeps returning an error message and I am not sure how to get what I want. Any help will be greatly appreciated! -- Melissa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
XL2003 FILTER FUNCTIONS VS. XL2007 FILTER FUNCTIONS | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions |