Ignoring Cells through IF Functions

H

Hamed parhizkar

In cell A1 i have 200, in cell A2 I have 250

In cell A3 I have an if function =if(a1<>0,A1,"")&if(A2<>0,A2,"")

My question is, can I make a formula to say that if A2 is 0 then it would
ignore cell A1... So if A2 is blank, then my output would be blank???
 
H

Hamed parhizkar

This works but the problem with this is, I have more formulas in this cell
after this if function, so when a2 is 0 then it blanks out the rest of the
cell, I need the rest of the formula to work even if it zero's out.
 
S

StumpedAgain

You can programaticly do this through an if, elseif, else statement. You'll
have to be more specific if you want more specific help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

matching cells 3
Excel formula, sum the value cell and if empty cell left blank 0
excel formula 1
VBA Linest function for polynomial regression on horizontal range 0
Re. Conditional formating of adjacent cells but down a column 0
How to delete ALL cells containing the same data 1
Copy and Paste using VBA. 2
Macro 1

Top