Formula for multiple if blank arguments

Question

I am trying to build a formula for the following problem:

• If A and B are blank then C should be Blank.
• If A isn't blank but B is blank then C should be blank.
• If neither A or B are blank C should return the value of B

I have this part so far:

=IF(OR(ISBLANK(Mon!$C$14),(ISBLANK(Mon!D8))),"",(Mon!$C$14))

Answer 1

You could try:

=IF(COUNTA(A,B)=2,B,"")

So in your case:

=IF(COUNTA(Mon!C14,Mon!D8)=2,Mon!C14,"")

Answer 2

=if(isblank(B), "", if(isblank(A), "", B))

Alternatively:

=if(or(isblank(A), isblank(B)), "", B)