Search results

Actually, your solution worked. The only change I had to make is marked in red in the formula below. It seems that there is an extra and unnecessary comma. Your Solution =IF(AND(A2<>I1,D2<>I1,),"",whatever you want here?) My full formula =IF(AND(A2<>$I$1,D2<>$I$1),"",IF(A2=$I$1,B2,IF(D2=$I$1,C2)))

arnelgp NO, i'm sorry, I probably didn't make myself clear. It should be an either/or statement. If (A2) or (D2) = (I1)

Solution found!!! (Thank you Gasman). =IF(AND(A2<>I1,D2<>I1,),"",whatever you want here?) The only change I had to make is marked in red in the formula above. It seems that is an extra and unnecessary comma. Thank you everyone for your help!

Hello Excel Experts! Attached I have an example of what I am trying to accomplish. Simply put, I would like the cells in the "I" column to show a blank if A2 & D2 don't equal I1. I have tried every way I can think of (Except the correct way of course) and unable to get it to work. Any help...

I'm sorry, it was a EBTLAC error. (ErrorBetweenTheLaptopAndChair). The formula provided worked perfectly. BTW: The Or statement would not work (Unless it was nested further) because most of the time either field is blank thus causing the field to show blank. Thanks again for all the help!

Thanks Isaac for the completed formula. One problem though, When I put the formula in it came up blank. It don't seem like it's getting past the first if statement. I want it to show me the total if either or both fields have a number in it. Should the first if statement be at the end? Thanks...

Thanks for the quick response. If either field is empty I get an error message (#Value). I want it to show me the total if either or both fields have a number in it. I'm sorry, I meant to stated that in the original post.

In L14 I did =H14 & I14 & J14 K14

I have a problem with a formula that I know the Excel experts here can help me with. In the attached spreadsheet I want to add H13 & J13 together and put it in K13. I tried to combine the formulas in C15:C18 into one formula but I get a #Value error. I broke down the different parts of the...