logic test

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...

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...

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...

" 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...

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...