SOLVED

multiple IF statements

Copper Contributor

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 still pull in as 0  thx.

 

the formula needs to read:

 

If the cell value is 0, put 0

If the cell value is "" (blank), leave blank

otherwise pull the value entered in that cell

2 Replies
best response confirmed by HansVogelaar (MVP)
Solution

@Jennyge Would this not work for you?

Riny_van_Eekelen_0-1689767135618.png

 

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.
1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

@Jennyge Would this not work for you?

Riny_van_Eekelen_0-1689767135618.png

 

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.

 

View solution in original post