Results 1 to 5 of 5

help with IF function returning a false result instead of a true result

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2021
    Location
    england
    MS-Off Ver
    2016
    Posts
    10

    help with IF function returning a false result instead of a true result

    basically i want the function to return a TRUE value result instead of a false one based on these numbers

    the formula i want to calculate is:

    price * quantity - actual price = discount price

    as you can see in the file i uploaded a one line example that the formula is true but it gives a false statement.

    thank you for your help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF, AND, OR Function:True is equation with neg result, False is equation with pos result
    By MrSurveyor in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-06-2021, 07:18 PM
  2. [SOLVED] If the IF function result is false then check the next cell until get a true result
    By Beag air Bheag in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-10-2017, 08:55 AM
  3. Can Excel operate a function based on a true or false result?
    By SteveD in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  4. [SOLVED] Can Excel operate a function based on a true or false result?
    By StinkeyPete in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 09:05 AM
  5. [SOLVED] Can Excel operate a function based on a true or false result?
    By SteveD in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. [SOLVED] Can Excel operate a function based on a true or false result?
    By SteveD in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] Can Excel operate a function based on a true or false result?
    By SteveD in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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