Results 1 to 17 of 17

Nested IF (AND) FUNCTION

Threaded View

  1. #1
    Registered User
    Join Date
    02-10-2016
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2007
    Posts
    13

    Nested IF (AND) FUNCTION

    Hi Guys,

    I want to know how can i use a Nested IF(AND) function. I am using the formula below but it is showing me error, can anyone help:
    =IF(AND(B3="SPAN",C3="SAIB",D3>=5000),40,D3*0.008),IF(AND(B3="VISA",C3="SAIB",D3>=0),D3*1.18%,0)

    Where can i find the link to attach my excel??
    Last edited by balsharaf; 11-13-2017 at 03:19 AM. Reason: Attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Nested vlookup or nested IFAND function?
    By jeptik in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2017, 02:27 AM
  2. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  3. COUNTIF/COUNTIFS function + nested user-defined function
    By shamjamali in forum Excel General
    Replies: 1
    Last Post: 05-12-2015, 09:12 PM
  4. [SOLVED] ROUNDUP function nested in IF function--Having problems!
    By whitequeen11 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-08-2014, 04:32 PM
  5. [SOLVED] Nested Function With Division - Receiving #VALUE! Function Error
    By DDM64 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-17-2013, 01:16 PM
  6. [SOLVED] Nested AND function within IF function is only addressing logical1 but not logical2
    By betic in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2012, 09:17 AM
  7. Offset function with nested match function not finding host ss.
    By MKunert in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2006, 06:50 PM

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