Results 1 to 8 of 8

Logical check working some of the time

Threaded View

  1. #1
    Registered User
    Join Date
    07-08-2016
    Location
    United States
    MS-Off Ver
    2013
    Posts
    4

    Logical check working some of the time

    Hello everyone! Please see attached image. I created this formula last night to basically create a bill of materials for my order list (circled in blue). It's saying if the column H values are equal to the column D values and if the column E values are equal to 0.75 (it's coincidence that they are all the same), then sum the quantity of that size.

    So here, I have 1 that is 5.5x.75, 2 that are 5.75x.75, and 1 that is 6.25x.75. My question is why isn't my formula working for the ladder size? It works for the first 2 but not the 6.25. I'd appreciate any kind of help!!

    Thank you
    Scott

    Logic question.JPG
    Last edited by scarpbot; 07-08-2016 at 11:32 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA UserForm.Value Check If User Form Buttons checked Not Working. Check Button on Open.
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-11-2016, 05:55 PM
  2. Time Calculation using Logical function
    By L Raju in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2014, 04:00 AM
  3. [SOLVED] Accounting logical test to cross check columns and rows, not allowing pence
    By RoyLittle0 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-16-2014, 01:07 PM
  4. logical and time calculation problem
    By wba in forum Excel General
    Replies: 4
    Last Post: 07-01-2012, 07:05 AM
  5. IF Logical Test for Time Range In Cell
    By Bob McCusker in forum Excel General
    Replies: 8
    Last Post: 07-23-2010, 04:58 AM
  6. logical test not working
    By arora in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2008, 05:08 AM
  7. IF and many logical tests at same time
    By saurya_s in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-21-2007, 10:45 AM

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