Forum Discussion

Theresa4372's avatar
Theresa4372
Copper Contributor
Jun 13, 2022

formula/Functions support in Excel

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

excel
Excel on Mac
Formulas and Functions

5 Replies

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jun 13, 2022

    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)

    • Theresa4372's avatar
      Theresa4372
      Copper Contributor
      Jun 13, 2022
      the content I am pulling contains numbers and texts OR it will be blank.
    • Theresa4372's avatar
      Theresa4372
      Copper Contributor
      Jun 13, 2022
      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)).
    • Theresa4372's avatar
      Theresa4372
      Copper Contributor
      Jun 13, 2022
      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.

Resources