logic test

  1. M

    Logic Test Comparing Names in a List

    I have a cost spreadsheet that pulls from a database. We have trouble with accounting not setting the employees rate or classification correctly. I am trying to make a logic test that would check a concatenation of the user name, classification, and rate against a master list set up for the...
  2. S

    Dynamic IF formulas

    Hi all, I'm fairly new to excel, so I hope you can help me. I have a large dataset with monthly tracking data. In one of the sheets i perform a lot of "conditional checks" (typically IF formulas). The problem is, that when new variables are added to the data set, the IF formulas refer to the...
  3. J

    IF logic test help

    Good Morning I need help determining my misstep in creating this formula: it returns the same response for failure as excellent. I need it to answer 5 points for excellent and 0 points for failure. All the others work and respond with appropriate responses. thanks for the help...
  4. J

    Trying to make an equation and an "IF" logic test only occur after a date, help

    " http://tinypic.com/view.php?pic=35d5nas&s=5 "*Image of print screen of my situation Hi i am trying to create a dynamic personal accounts table in which to account for all of my inflows and out flows on my from my bank account, at the bottom i have created a simple balance checker which checks...
  5. R

    logic test output to seperate cell

    I am developing a sheet to do some debt analysis. I have an input cell for loan value (B1), interest rate (F1), term (months)(H1), and payment(J1). I also have a set of cells that will calculate each of these values individually, given the other 3 values (J4-7 respectively). What I am trying...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top