Questions tagged [blank]
10 questions
6
votes
3 answers
Excel IFBLANK equivalent for IFERROR
IFERROR works great because it shortened the formula significantly by having a default behavior, returning the results if condition is not met (no error).
I'm looking for the IFBLANK version of this behavior, i.e. return results if condition is not…
mrr010
- 97
- 1
- 8
1
vote
0 answers
How do I keep the cell blank when the formula outputs nothing, so that the text from the previous adjacent cell can overflow in it?
I have a basic Excel IF function that shows a computation result if the condition is TRUE.
What I am trying to figure out how is, in case the condition is FALSE, how to keep the cell blank so that text from the previous, adjacent cell can freely…
kaboom1
- 3,027
- 2
- 14
- 5
0
votes
0 answers
How do I extract a single list of 3D spatial coordinates across 2 different sheets that link the 3 cartesian planes?
I am using Excel to draw an ellipsoid that is rotated by 15 degrees. What I want is not a 3D plot of it, but I want to get a list of all the coordinates that share a certain criteria. An example is shown below that illustrates this exercise:
X-Z…
Haziq Bin Yazid
- 1
- 1
0
votes
0 answers
User with blank detail in output
As per the attached screenshot, I need a formula to derive user with a blank cell to be shown as pending. (Pending has been manually entered.)
Kazim H
- 1
0
votes
2 answers
Vlookup with Blank cell
Vlookup with Blank cell
I have a Vlookup formula that I want to return "" if the value is empty.For example: =Vlookup(D2, sheet 1,A2:D2,3,0)
Iraj7280
- 13
- 1
- 4
0
votes
2 answers
concatenate with ISBLANK and delimiter
I am attempting to combine two columns in Excel 2016, with a space between the results. My problem is being able to use ISBLANK to ignore blanks on either column, and still have the space delimiter in the final result when two fields are…
Rick Kirkman
- 3
- 2
0
votes
2 answers
How do you create a formula whose output is a BLANK cell?
How do you create a formula whose output is a BLANK cell?
Remember a cell whose result is "" is not BLANK.
For example, =ISBLANK(IF(1=1,"","")) results in False.
0
votes
2 answers
MS Word - pasting link into text box from Excel inserts 2 blank spaces above data
I'm trying to automatically update some text boxes in Word using an Excel sheet, i.e. copying a cell in Excel, right-clicking in the text box in word and choosing the 'Link & Merge Formatting' option.
The link works, but inserts 2 blank…
Oursoul
- 1
0
votes
2 answers
Is there a way to copy all empty cells in a data set on one sheet and paste the empty cells into a data set on a different sheet?
Is there a way to copy all empty cells in a data set on one sheet and paste the empty cells into a data set on a different sheet?
For every cell in the “Sales Sheet” that is blank, the corresponding cell in the “Inserts” tab also has to be blank.…
Nina
- 1
0
votes
1 answer
How can I prevent .txt files loading in binary, and recover the alphanumeric content of those that insist on doing so?
I'm using TED Notepad in Windows 10.
When I try to open some of the .txt files I've edited in the last few days, I receive the following message: "Warning: Loaded file is binary. Edit with care." I click on OK, and the file is blank - though if I…
Dade McDade
- 176
- 1
- 7