Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-28-2013, 01:13 AM
Jamal NUMAN Jamal NUMAN is offline Multiple If statements, Windows 7 64bit Multiple If statements, Office 2010 64bit
Expert
Multiple If statements,
 
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question Multiple If statements,

Multiple If statements,



I wanted to code an If statement that meet the cases below but sounds not to work with me.

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
If A<0 and B<0 then X=3B-9


It works for the first condition but couldn’t know how to proceed (attached)


Thank you


Best

Jamal
Attached Images
File Type: jpg Clip_15.jpg (121.3 KB, 46 views)
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple If statements, 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
Multiple If statements, 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft