formula/Functions support in Excel

Occasional Contributor

I am trying to create a daly calendar for my father... If the cell (c1:c2) has content on the weekly calendar (sheet 1), I want to to go to a specific cell (c1:c2) on the daily calendar (Sheet 2). If their is nothing in the cell, I want it blank. Right now a "0" appears

5 Replies

@Theresa4372 

See formula or function in excel help 

 

If the cell referred to contains text if it isn't empty, you can use a formula such as

='Other Sheet'!C1&""

where Other Sheet is the name of the sheet you want to refer to.

If the cell might contain text or a number, use

=IF('Other Sheet'!C1="","",'Other Sheet'!C1)

HERE IS WHERE I AM STUCK... this is the formula I am using...
=IF(Monday!C3:D3=Monday!C3:D3,"_")
MEANING: If monday!c3:d3 has content, then pull that exact content. If there is not content then keep it blank.
THANK YOU FOR YOUR HLEP, BUT I AM STILL CONFUSED... THIS IS WHAT I TRIED AND STILL DOES NOT WORK. =(


=IF(Monday!C3:D3('Monday!C3:D3="",""'Monday!C3:D3)).
the content I am pulling contains numbers and texts OR it will be blank.

@Theresa4372

 

Try

 

=IF(Monday!C3="","",Monday!C3)