 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Logical Formula
I need to check two conditions in a cell and then return the value if true or false. I am using the IF function, but not getting thru the second logical condition to be applied. Thanks in advance Mustafa Post your formula, pl.  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- >I need to check two conditions in a cell and then return the value if true >or [quoted text clipped - 6 lines] > > Mustafa Max, This is the formula =IF(F739="Renew",550,IF(F739="Urgent",260),150) Mustafa > Post your formula, pl. > >I need to check two conditions in a cell and then return the value if true [quoted text clipped - 7 lines] > > > > Mustafa Thu, 3 Jan 2008 03:13:00 -0800 from Mustafa S N <MustafaSN@discussions.microsoft.com>: > > > I need to check two conditions in a cell and then return the > > > value if true r false. [quoted text clipped - 5 lines] > > =IF(F739="Renew",550,IF(F739="Urgent",260),150) Your parentheses near the end are wrong. An IF needs three arguments, but your outer IF has four and your inner IF has two. Change to =IF(F739="Renew",550,IF(F739="Urgent",260,150)) SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ Stan, Thanks a lot....it worked as required. Mustafa > Thu, 3 Jan 2008 03:13:00 -0800 from Mustafa S N > <MustafaSN@discussions.microsoft.com>: [quoted text clipped - 13 lines] > > =IF(F739="Renew",550,IF(F739="Urgent",260,150)) Thu, 3 Jan 2008 04:29:01 -0800 from Mustafa S N <MustafaSN@discussions.microsoft.com>: > > Thu, 3 Jan 2008 03:13:00 -0800 from Mustafa S N > > <MustafaSN@discussions.microsoft.com>: [quoted text clipped - 15 lines] > > Thanks a lot....it worked as required. Happy to help, and thanks for the feedback (even though it was upside down). SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.