IF AND Formula

**sharper1989** · 08-08-2012, 11:11 AM

Hi there,

I'm sure this will be a basic query for you guys but I can't get it to work!

I need a formula that will say;

If L2 = 0 AND K2 is a positive number, subtract K2 from M2. If not simply display M2.

But also , If L2 = 0 AND K2 is a negative number, add K2 to M2. If not simply display M2.

There's just too many parameters for me!

Any help would be really appreciated!
Thank you!

**Fotis1991** · 08-08-2012, 11:15 AM

Maybe?

=IF(AND(L2=0,K2>0),M2-K2,IF(AND(L2=0,K2<0),M2+K2,M2)))

**tigeravatar** · 08-08-2012, 11:21 AM

Alternate:

Please Login or Register  to view this content.

**sharper1989** · 08-08-2012, 12:17 PM

Thank you very much! I'm going to learn how to write an IF AND formula now, I promise!

**Cutter** · 08-08-2012, 04:52 PM

@ sharper1989

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.