“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

i am new to excel and need help. i have an ordering sheet and if someone orders for example a desk, they put that quantity in a cell A1, lets say 50. next they can order chairs but i have 2 types, so there is a cell A2 for chairs with wheels and a cell A3 for chairs without. is there a formula so that lets them order whichever combination of chairs chairs they'd like without exceeding the quantity total of the desks ordered? like if they wanted both they could order 25 each but not 25 and 26 because it would be over the 50 they ordered.

Solved by I. U. in 23 mins

I need to combine different files to into one file

Solved by C. D. in 19 mins

The following nested If/Vlookkup forumla returns "FALSE" but the lookups are correct - can you help fix the error or redo as IFS if better?

Solved by E. H. in 11 mins

looking for formula that will tell me that cell value is repeating during vlookup

Solved by G. H. in 27 mins

When I type something on a cell, for some reason another cell automatically starts copying what I am writing on the cell. For example I typed something on cell 4. Then on cell 10 when I start typing, cell 4 starts automatically typing what I am typing on cell 10. How do I make that stop?

Solved by M. A. in 22 mins

hello
looking for the right formula or function to work out :
if a code 1 is put in column 1
and
code 2 is put in column 3
what is the total of column 5
accumulated in totals cell
Thanks

Solved by A. Q. in 23 mins

I need help with this question:
A casino manager wants to introduce a Xmas game (that gives the customers an advantage). The Game: 1. A random colour machine displays either GREEN or RED. 2. Customer picks a colour and wins if their colour is displayed 3. A round involves 10 games. Of which GREEN is displayed 6 times on average (to give the customer an advantage) 4. Pay out is the stake x 0.7 (so if you select green and bet $1, your total return is $1.70 if green appears. But you lose $1 if red appears) (the customer still has a small advantage) QUESTION: What is the optimal betting strategy, to ensure that the customer wins $50 after every round (10 games) if the customer started with $100.
Just give me an idea about how can I approach this particular problem.

Solved by E. J. in 23 mins

I am working on a merit increase spreadsheet. I need to calculate the lump sum bonus increase for those employees over the maximum. The challenge is that there are 3 options: 1) The Merit increase doesn't take them over the max of the range 2) Part of the merit increase will take them to the max and the rest will be given as a lump sum bonus and 3) they start out over the max and 100% of the merit increase will be given as a bonus.
We can hide some of the columns but I do need to have one that has the final lump sum amount. .

Solved by C. E. in 18 mins

Worksheets Involved:
Column A of worksheet 'Key Issue Details' contains a list of exam titles
Column C of worksheet 'Key Issue Details' contains a list of corresponding exam types (Audit, Credit Review, etc.)
Cells A20:A22 of worksheet 'PickList' contain all of the possible exam types found in column C of 'Key Issue Details'
Column C of worksheet 'Calendar & Exam Summary' (cells A5:A16), contains an empty list for all Audit type exams
I want to enter a formula into cells A5:A16 on worksheet 'Calendar & Exam Summary' that will copy over all exam titles from 'Key Issue Details' column A, but only if 'Key Issue Details' column C matches any of the cells A20:A22 in 'PickList'.
I am using the formula below which does retrieve this information, however instead of copying them over one after the other in Column C ('Calendar & Exam Summary'), it is matching row for row. For example:
Formula being used: =IFERROR(INDEX('Key Issue Details'!$A$2:$B$2,MATCH(PickList!$A$20,'Key Issue Details'!$C$2:$D$2,0)),"")
'Calendar & Exam Summary' ...........'Key Issue Details'
C5 - ...................................C2 - Exam A (doesn't match PickList)
C6 - Exam 1.......................C3 - Exam 1 (Meets Criteria)
C7 - ...................................C4 - Exam B (doesn't match PickList)
C8 - Exam 2.......................C5 - Exam 2 (Meets Criteria)
C9 - Exam 3........................C6 - Exam 3 (Meets Criteria)
I would like it to look like this:
Calendar & Exam Summary ........ Key Issue Details
C5 - Exam 1........................C2 - Exam A (doesn't match PickList)
C6 - Exam 2........................C3 - Exam 1 (Meets Criteria)
C7 - Exam 3........................C4 - Exam B (doesn't match PickList)
C8 - .....................................C5 - Exam 2 (Meets Criteria)
C9 - .....................................C6 - Exam 3 (Meets Criteria)

Solved by T. S. in 18 mins

Good morning! I am trying to create this labour tracker that totals the weekly, monthly, and yearly hours that the employees work. The problem is that the boss wants it set up so that if we need to add an employee at any point during the year we don't have to change the formulas. Is this possible?

Solved by K. S. in 25 mins