Results 1 to 6 of 6

Need help with logic statement

Threaded View

MrGezus Need help with logic statement 09-16-2014, 04:29 PM
judgeh59 Re: Need help with logic... 09-16-2014, 04:36 PM
ben_hensel Re: Need help with logic... 09-16-2014, 04:37 PM
Zodeeak Re: Need help with logic... 09-16-2014, 04:38 PM
MrGezus Re: Need help with logic... 09-16-2014, 04:45 PM
ChemistB Re: Need help with logic... 09-16-2014, 04:40 PM
  1. #1
    Registered User
    Join Date
    08-25-2014
    Location
    Louisiana
    MS-Off Ver
    2014
    Posts
    17

    Need help with logic statement

    Okay, this will probably be the most horrible explanation ever of a problem but here goes...

    I have written a program which calculates weld times for job quoting. It works well when I use whole or half numbers for my weld thickness (1 or 0.5, 2 or 2.5).

    The problem exists when I enter a number such as 0.9 in my thickness (G13). When I do this it gives me a Zero (0) value near the bottom J51:J90. It does this because of my logic statement (=IF(A51=$K$13,H51,0)) When I enter the odd number in the G13 (such as 0.9) it will output a zero because it does not match the precedent.

    Can someone take a look at this for me and see where I went wrong? Is there an easier way to do this?

    https://onedrive.live.com/redir?resi...nt=file%2cxlsx

    I have attached a link and an attachment. They should be the same file.
    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. IF statement Logic..
    By inincubus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2014, 05:27 PM
  2. Logic Statement
    By jeanmuhree in forum Excel General
    Replies: 5
    Last Post: 02-20-2012, 03:10 AM
  3. Excel 2007 : If statement - logic syntax
    By Omegaman in forum Excel General
    Replies: 5
    Last Post: 04-27-2009, 12:25 AM
  4. Logic Statement
    By abierly in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2006, 02:15 PM
  5. Using 'AND' logic in a SUMIF statement
    By IpcTrain in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2006, 01:45 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