Forum Discussion
#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...
ituryu , you are welcome
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.
Did you try ='Client Info Sheet'!B6 ?
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.
That could be
=YEARFRAC(DOB,IF(DOD="",TODAY(),DOD))and apply desired number format to the result.