Forum Discussion

ituryu's avatar
ituryu
Brass Contributor
Jan 22, 2020

#SPILL! From a Referenced Merged Cell.

Hi everyone, I have a spreadsheet that I'm trying to build for my work flow to enable track my daily sales activities and simultaneously compute my percentage earnings per customer. For me to achieve...
Formulas and Functions
ituryu's avatar
ituryu
Brass Contributor

SergeiBaklan 

Thank you so much, the @before the formula worked. Now I'm ready to work on. 

 

Cheers.

  • Rebecca_L4's avatar
    Rebecca_L4
    Copper Contributor
    Oct 15, 2020

    SergeiBaklan I am trying to populate an empty merged cell with a merged text cell from one sheet to another. It is now displaying #Value! instead of the name I am trying to reference. For reference, the formula I am using is =@'Client Info Sheet'!B6:D6. 

      • Rebecca_L4's avatar
        Rebecca_L4
        Copper Contributor
        Oct 15, 2020

        SergeiBaklan THANK YOU. Yes, that worked perfectly. Now I have another question that maybe you can help me with. I have a cell on my spreadsheet that should show someone’s age (it should show either current age or age at death, whichever applies). I am trying to find a formula that would calculate these scenarios. I believe it should be an if/then type statement, because whatever the answer, it should populate this one cell. My spreadsheet currently has one cell with the today’s date (DATE), one for the date of birth (DOB) and a cell which would only be populated if the person is deceased (DOD). So, theoretically the age would be found using combinations of those three cells. 

Resources