IF and ISBLANK

P

projectnewbie

Please help me with the following problem. I did try to read through several
threads pertaining to IF and ISBLANK statements but none of them seem to have
the solution for what I need. I apologize in advance if I am making a
duplicate request.

I am try to write a statement using IF and ISBLANK to return a value in a
column. For example, I need a value returned in Column "M" with these
statements:
If Column I and I are BOTH blank, leave blank.
If Column I is blank but Column L is NOT blank, subtract I from L.
If Column L is blank, leave blank.
If column L and I are NOT blank, subtract I from L

Thank you in advance for your response.
 
J

Joe Mac

try this -

=IF((AND(ISBLANK(I1),ISBLANK(L1))),"",IF(AND(ISBLANK(I1),ISNUMBER(L1)),L1-I1,IF(ISBLANK(L1),"",L1-I1)))
 
P

projectnewbie

It worked! Thank you so much.

Joe Mac said:
try this -

=IF((AND(ISBLANK(I1),ISBLANK(L1))),"",IF(AND(ISBLANK(I1),ISNUMBER(L1)),L1-I1,IF(ISBLANK(L1),"",L1-I1)))
Click to expand...
 
P

projectnewbie

Your suggestion worked as well! I really appreciate the rapid and helpful
response.
 

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

Dealing with the error: unable to filter on excel hc home school 0
Publisher adding blank page when printing my booklet... 2
Dealing with a Pivot Table (when I don't want to) 0
if(and(isblank( formula help 2
If Not blank - Formula for two cells 0
Quick Parts / SharePoint Library Update 0
Set as Default Template not working 0
Two columns followed by single page-width column on same page 0

Top