I need a formula that does the following:
Put the content of B2 into C2.
Exception: if B2 is blank, then put “zzz” into C2.
Could anyone please help me?
LO 7.181
macOS
You sureley mean the formula =IF(B2="";"NNN"; B2) entered into Cell C2.
You can’t put anything anywhere by an ordinary formula. Only the result calculated as the formula tells is returned to the cell where the formula is positioned.
The formula posted above doesn’t exactly what you asked for. I assumed you weren’t interested in the difference between a blank cell and one containing a formula returning an empty string.
Tchnically (and relevant for some applications) there is such a difference, and if the exception actually should only apply to blank cells, you need to use =IF(ISBLANK(B2);"NNN"; B2) .
3 Likes
Thanks! I edited my answer respectively.
The “N” were for you.
Yes, I understand - for this separately “Thank you”
Thank you all for helping so quickly! The IF formula (without ISBLANK) does work for my current purposes.