Forum Discussion
Solved
multiple IF statements
How can I pull from a column on a separate sheet with multiple conditions? I can get two of the parts of the formula to work but not all. I can get any of the numbers to pull in but the blanks stil...
Jennyge Would this not work for you?
It returns a blank is the cell in A is blank. Otherwise it returns the value in A, be it 0 (zero), any other number or a text.
Jennyge Would this not work for you?
It returns a blank is the cell in A is blank. Otherwise it returns the value in A, be it 0 (zero), any other number or a text.
I clearly must have had something wrong in my original formula because I was pulling a 0 instead of a blank. That's formulas 101. Thanks for helping my overthinking.