I have a spreadsheet that allows the user to input different employee/bonus combinations and based on the combination, I have assigned a number 1-4. For instance:
A = 1
A+B = 2
A+C = 3
A*B = 4
I created a large nested IF statement to account for every combination, but I have two combinations...
I have a workbook where I am importing data from 2 external reports (CSV to Excel format), and I have to find matches between both reports to determine matching criteria. Once I have this match completed I am pulling the results into another worksheet (all same workbook), for displaying in a...
Good afternoon whizzy Excel people, I wonder if anyone can help me solve a problem that I'm trying to come up with a formula for, I'm usually pretty good at this sort of thing but this one is eluding me, no doubt someone out there has a simple answer using a function I haven't come across yet...
I have a report that has individual data set up in form format, however, I want to pull the information from each of the worksheet into a data minable spreadsheet without having to reformatted each individual spreadsheet. Is this possible. I have attached an example.
As you can see it is not...
I have an existing cell formula :
I need to add a function so that if the value returned is a negative number, it equals "0". Not sure if
i should combine in an "IF" statement or what...
Relatively I am new to this forum, when I say relatively, I have been using this forum just to search and get answers for all my excel related queries for almost 6 years now and haven't posted anything or even registered. Thanks to all the experts who have helped me so for!
I want to combine below 2 formula in one. importantly: 1st condition should be first checked & then second.
if false then
=IF((O27="Chairs")*AND(L27="2"),"30 days time","")
I was hoping to find a thread on this somewhere, but after a few hours of looking around without success, I decided to just post it here and hoping someone can help me out.
I'm trying to display the total number of possible scenarios for my fantasy baseball auction draft. Here are the details...