Results 1 to 3 of 3

Min formula with blanks or zeros

Threaded View

  1. #1
    Registered User
    Join Date
    05-05-2016
    Location
    Melbourne
    MS-Off Ver
    Excel 2016
    Posts
    31

    Min formula with blanks or zeros

    Hello.

    I have attached a spreadsheet that I am having trouble with in relation to code # 7.

    This calculation needs to give a result of either the lowest of total limit, 80% of the extended quote or ADA schedule

    If there is no amount in the ADA schedule cell or blank, needs to ignore this part of the formula. & validate based on the other two (2) criteria

    Thank you
    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] formula to show blanks instead of zeros
    By chubbychub in forum Excel General
    Replies: 15
    Last Post: 09-17-2016, 02:59 PM
  2. [SOLVED] IF(OR Formula Displays Zeros instead of Blanks
    By GeoffH1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2016, 07:37 PM
  3. Replies: 8
    Last Post: 12-31-2014, 11:48 AM
  4. Replies: 7
    Last Post: 05-28-2014, 01:20 AM
  5. Fill blanks with zeros
    By Snark in forum Excel General
    Replies: 1
    Last Post: 07-15-2008, 04:33 PM
  6. Blanks chart as zeros
    By CLR in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 04-10-2005, 09:06 PM
  7. Ignore blanks or zeros
    By gil0730 in forum Excel General
    Replies: 1
    Last Post: 02-03-2005, 12:12 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