![]() |
|
|
|
#1
|
||||
|
||||
|
Sorry you don't seem to understand my question Hope someone else can help you
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
#2
|
|||
|
|||
|
Quote:
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 -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 |