incorporate cell name in output

Topic

New Reply

I am using the formula “=IF(ISERROR(DATEDIF(B10,B11,”d”)),”no next date”,DATEDIF(B10,B11,”d”))” to output column “C”.
I want to output a cell name [B11] in output text [C10] so it would read “no entry B11”. Is it possible to use a formula that would calculate the cell to be placed in the output? I do not want to write a specific formula for each “C”.

See attached spreadsheet.

Thanks.

Reply | Quote

Replies

…….
See attached spreadsheet.
…….

Nothing was attached.

Try this within your formula for C10 …
“no entry”&” “&CELL(“address”,B11)

Reply | Quote

Incorporate the following into your formula:

=Cell(“address”,B11)

It will return $B$11 as text

when you copy down the next cell would be $B$12 etc. If you copy right the next cell would be $C$11 etc.

Hope this helps.

Tom Dutie

Reply | Quote

Thanks.

Anyway to eliminate the $s ?

Reply | Quote

Thanks.

Anyway to eliminate the $s ?

Try this to eliminate the $’s…..
“no entry”&” “&”B”&CELL(“row”,B11)
Assumes you always want a cell from Col B.

Reply | Quote

Anyway to eliminate the $s ?

=SUBSTITUTE(CELL(“address”,B11),”$”,””)

Steve

Reply | Quote

Tim, Tom, Steve, Thanks.

Tim, your suggestion to eliminate $ worked fine.

Steve, How would I incorporate your formula into my modified formula?
=IF(ISERROR(DATEDIF(B10,B11,”d”)),”no entry”&” “&”B”&CELL(“row”,B10),DATEDIF(B10,B11,”d”))

Reply | Quote

Steve,
Never mind, I figured it out. Thanks.

Reply | Quote