+ Reply to Thread
Results 1 to 2 of 2

Syntax for IF AND Excel 2010

  1. #1
    Registered User
    Join Date
    02-14-2012
    Location
    High Desert, CA
    MS-Off Ver
    Excel 2010
    Posts
    37

    Syntax for IF AND Excel 2010

    I am having trouble getting syntax right using IF and AND in Excel 2010

    what I want to do is perform an operation in a cell wherein:

    IF A99 = "Basic" AND D105="Distance Between Corners" then D104 otherwise 1.154*D104

    Thanks in Advance!

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Syntax for IF AND Excel 2010

    Try this one.

    =IF(AND(A99="Basic",D105="Distance Between Corners"),D104,1.154*D104)
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 10-06-2015, 10:54 AM
  2. UDT passing byref works in WinXP Excel 2010 fails on Win7 64 bit Excel 2010 32 bit
    By MarkInKeizer in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-09-2014, 11:49 AM
  3. Excel 2010, Access 2010, SQL Insert and Update Statments and NULL value in Field
    By jmmach72 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2013, 02:35 PM
  4. Copying worksheets from excel to word in vba as images
    By papasideris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2012, 11:32 AM
  5. Searching the particular numberfrom excel'2010 table and locate the number in Word'2010
    By jaffirahamed1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2012, 08:09 AM
  6. Formula Syntax Query - Excell 2010
    By Matt_Cox in forum Excel General
    Replies: 7
    Last Post: 07-29-2010, 07:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1