Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If function across sheets prints value of cell
I am having a problem with this function.
I would like to look up a cell in sheet1 if the cell value is 0 then I would like the cell on sheet2 to read ----- if the cell value is anything else I would like the value of that cell to populate the new cell I have it working halfway with this formula =IF(Sheet1!C1=0," ","Sheet1!C3") I get the ----- when I need it but get Sheet1!C3 instead of the value sheet1 cell C3 contains. I tried =IF(Sheet1!C1=0," ","=Sheet1!C3") but that didn't work. i searched the net but couldn't find the answer there either. Any possible help for a newbie? All this is to help my cause of generating cleaner code when using excel data to make a table in an HTML email. When I create the code Dreamweaver HTML editor will only put borders around cells with values in them.   is the value for 'NON BREAKING SPACE' which displays as a blank. But I can not get the value of the cell to display if it is not originally blank on sheet1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with printing multiple sheets-only 1 sheet prints in color, other sheets print in B&W | Excel Programming | |||
Help to amend code which prints only certain sheets | Excel Programming | |||
when printing multiple sheets, first prints single side rest doub. | Setting up and Configuration of Excel | |||
Spread sheets for keeping records of Art prints, printing & sales | New Users to Excel | |||
Excel prints some sheets very small | Excel Discussion (Misc queries) |