Hi all,
In my worksheet there are two cells D8 and E8 where I have to input data and the outcome of the formula will be visible on M8 cell.
Below is the tabular representation of data input in cells, and their expected output
<tbody>
Value in D8
Value in E8
Outcome
E
E
10
NA
E
10...
Hi, been a while since last time...
Right now I have a large amount of calculations that produce a range (results) of outcome on the spreadsheet (calc). A single input change all the outcome. I have a macro that loop through all the input (1...1000), copy results and then transpose and paste...
Hello
Trying to create an achievement outcome workbook for students in a debating competition.
I believe I need nested formula which produces Average, Good or Fantastic outcome based on multiple conditions.
Condition #1 - a validation List of student class Levels - F1,F2,T1,T2,E1,E2,E3,M...
So I got a new computer and on it came Office/Excel 365. I pulled open one of the spreadsheets that I have been working on and figured out that the "-" key doesn't work when it is the first key pushed in a cell. For example: If I want to put in a negative number I would input -123, the...
Hi All,
First time posting, been a long-time reader.
I have a question that I'm sure would have been looked in to before but cant seem to get a fix via solver or any of my own VBA work.
I have a model with 96 different possible outcomes dependent on the variables in 4 different drop down...
Hello
I need to 'de-code' someone else's left over codes..and have come across this line
Range(Range("Outcome"), Range("Outcome").Offset(UBound(meanoutput, 1), UBound(meanoutput, 2))) = meanoutput
I suppose that I will need to replace "Outcome" with something else, but first I will need to...
Here is a picture of my spreadsheet and what I am trying to figure out how to get it to do what I need it to do:
The selected row (row 5) shows some cells that contain either a value of either "R" or "E". I need a If statement that checks a range of: Range(Cells(5, 6), Cells(5, lCol)), but...
Hi everyone. My first post here but used as inspiration many times.
The original data is on A1:F14 and the desired outcome in K1:M14. I`m looking to use less columns to show attributes for each ID on column A. The single restriction is that the unique strings must be placed on the same column...
Hello Guys,
I have sheet in which one order is repeating with changing its outcome. So, I want to apply conditional formatting for that particular order if there is difference between next outcome & first outcome, not more than 30 minutes.
Please tell me VBA code regarding this
I wanted to see if there is a way to create a button in excel. When clicked on it will give an outcome based on an average. For instance, if in a cell I had the average of a batter in baseball. Would I be able to create a formula to calculate if an at bat results in a hit or an out when a button...
I have never used index/match and dont know if that is even answer
I have a large sheet with colmns from colun C to column AE and rows 12 to 3000
I have a unique reference in cell E26 for example and say AC15..i then have various columns populated
The outcome for ref AC15 is in cells T26 to...
Hi guys
i have the data below which defines the rule of YES/NO and Final Outcome
<tbody>
<tbody>
name
set
status
action
YES/NO
Final Outcome
TRUE
TRUE
yes
install
FALSE
TRUE
yes
close
TRUE
FALSE
no
fix
TRUE
TRUE
no
freeze
yes
leave
</tbody>
</tbody>
I need a If...
Hello - this is my first post on this forum !
I might not be an excel Master, but I do work a lot with it and on pretty complex formulas, but on this one I feel stuck, close to a solution that eludes me everytime :).
I have attached a file with the data and the desired outcome. Basically I...
Hi there,
I have a sheet that shows the number of hours above or below a standard working day a person has worked. I need to then sum these. The formula I have (column R) is fine if the outcome is positive (row 3) but not when negative (row 4). Any ideas please...
Hi everyone,
I'm trying to link 3 drop down lists together, which will lead to True/False outcome.
I have tried IFS statement, but I think it's too cluttered and might not be the best option.
My other option is to create variables for each category, but I'm not sure how to do it in Excel (my...
Hello, I need help with a long column that I need to substitute a character . with - in each cell but for some cells it applies the date format and messes up the outcome. I ve tried everything,
Dear friends,
I have a few lists of data where my desire outcome should reflect only the numbers after the decimal places. Example
<tbody>
List 1
Result
List 2
Result
List 3
Result
4.001
0.001
4.1
0.1
4.01
0.01
4.002
0.002
4.2
0.2
4.02
0.02
4.003
0.003
4.3
0.3
4.03
0.03
4.004...
Hi All,
Hope someone can help with this...
I have 8 statements that can all have an answer between 0 and 4, if the statements total a value between two numbers this produces a pre-defined outcome, however what I have been asked to do is if all statements have an answer of 3 or 4 and only one...
Hi All,
I have been tasked to prep a large amount of data for mail merge.
However I am faced with this challenge.
Can anyone help me, I am thinking an IF statement may work...
Here is a snap shot of the basic data (Not real data)
A B C D E F...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.