IF ISBLANK formula (Excel 2003)

Topic

New Reply

I looked through some old posts to find a way to add to this formula:

=IF(ISBLANK(L3),(SUM(M3-J3)),””)

I need to add cell G3 to the ISBLANK statement. I did see a post (#482685) that has a formula that looks for multiple blanks, but could not get it to work for me.

=IF(ISBLANK(A5);ISBLANK(B5);LEN(B5)=4)

What am I doing wrong?

Reply | Quote

Replies

Is this what you want:

=IF(AND(ISBLANK(L3),ISBLANK(G3)),"",(SUM(J3:M3)))

It is a little hard to figure out what you want from your formula. If that is not what you want, could you try explaining it in words?

Reply | Quote

Thanks Legare!

I knew there had to be a way to get AND in this formula. I modified yours slightly to get the result that I needed.

=IF(AND(ISBLANK(L3),ISBLANK(G3)),(SUM(M3-J3)),””)

Thanks again!

Reply | Quote