Multiple If statements,

Jamal NUMAN · #9 07-29-2013, 01:30 AM

Quote:

Originally Posted by Pecoflyer

Sorry you don't seem to understand my question
Hope someone else can help you

Thank you for the prompt help.

Apologies to not be able to well explain what I want. If you allow me, I’ll be trying to explain what I need once more.

Please, consider the values of A and B and the calculated value of X (attached)

A

B

X

1

11

12

2

-12

14

-5

12

-22

-1

-2

These calculations are made based on the conditions below

if A>0 and B>0 then X=A+B
If A>0 and B<0 then X=A-B
If A<0 and B>0 then X=2*A-B
If A<0 and B<0 then X=3B-A

My issue here is that I couldn’t code these conditions in excel

Best

Jamal

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Please tell me it doesn't take 7 statements to turn table borders off	Jennifer Murphy	Word VBA	5	07-25-2012 03:12 PM
showing results of If statements in a mail merge	m&co	Mail Merge	3	01-06-2012 07:27 PM
Multiple Input, Multiple Digital Signatures	Jeff	Word	0	01-04-2012 09:03 AM
Multiple task lists and multiple calendars	kballing	Outlook	0	01-18-2011 10:23 AM
IF statements that shifts to right.	kent	Excel	0	01-19-2006 02:23 PM