Text formulas returning 0

sassriverrat

Well-known Member
Joined
Oct 4, 2018
Messages
617
Suddenly all of these formulas (like below) are no longer just returning words, they are returning 0's. All of the other cells referenced have words in them.

Code:
=IF(Developer!J46="Network","C: Drive Daily Archive", Developer!E42 & " Daily Archive")
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,341
Can't see how that would happen if you have the text returning whether the IF is TRUE or FALSE.

Remove any sensitive information, upload the file to an online storage site and post a link here, it's the only way of solving this.
 

Forum statistics

Threads
1,089,269
Messages
5,407,301
Members
403,131
Latest member
Lewas2019

This Week's Hot Topics

Top