Results 1 to 5 of 5

having trouble with nested IF function

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2019
    Location
    Michigan
    MS-Off Ver
    MS Office 365
    Posts
    2

    having trouble with nested IF function

    =IF(Amount_Purchasing>0,Current_Processing_Fee,IF(Amount_Purchasing>=10,Current_Processing_Fee+Extra_Handling,"-"))

    I am creating a buy sell ticket for a school project and this is supposed to have a processing fee of $2.00 (Current_Processing_Fee) unless the user enters an amount of 10 or above in the Amount_Purchasing column, in which case it should ADD Current_Processing_Fee+Extra_Handling however it isn't. I continue to get the $2.00 original amount.

    I have also tried the following format with the same results:

    =IF(Amount_Purchasing>0,Current_Processing_Fee,IF(Amount_Purchasing>=10,Processing_Fee=Current_Processing_Fee+Extra_Handling,"-"))
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trouble with nested If's
    By KimMorgan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2019, 05:16 PM
  2. [SOLVED] Trouble with nested for loops
    By excel_novice2019 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-25-2019, 08:44 PM
  3. Replies: 2
    Last Post: 01-05-2019, 03:33 AM
  4. Trouble with nested if function
    By faodavid in forum Excel General
    Replies: 2
    Last Post: 02-02-2015, 05:07 AM
  5. [SOLVED] Having trouble using a nested IF with VBA msgbox
    By msantucci in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-07-2015, 03:19 PM
  6. [SOLVED] Trouble with Nested If
    By shaught7 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-25-2014, 02:26 PM
  7. Trouble with Nested IF Function
    By gvishnu in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-25-2013, 05:18 PM

Tags for this Thread

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