If function across sheets prints value of cell


N

New_to_accounting

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. &nbsp 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
 
Ad

Advertisements

D

Don Guillett

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. &nbsp 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
 
D

Don Guillett

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. &nbsp 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



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. &nbsp 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

Sheet1!C3
 
N

New_to_accounting

Sheet1!C3

Not sure exactly what that means. I did try that as the false value
but it just populates that. Not the actual contents of cell C3 on
Sheet1
 
Ad

Advertisements

A

arogg

Not sure exactly what that means. I did try that as the false value
but it just populates that. Not the actual contents of cell C3 on
Sheet1

He means you have to remove the quotation marks around the false condition if you want the value to display:

=IF(Sheet1!C1=0," ",Sheet1!C3)

Allan Rogg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top