outcome

  1. E

    Formula Audit

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

    Possible outcome results of 8 soccer matches for 'home', 'draw, 'away'

    Yes I understand that the total number of possible outcome results is 6561. But how can I get there? Any formula in excel? Kindly assist. Thank u
  3. H

    Add ranges to array

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

    Functions IF(AND( functions – multiple conditions I get #VALUE or FALSE Error

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

    "-" Sign Isn't Working on the Keypad

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

    All possible outcomes from drop-down lists

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

    Range question needs explanation

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

    VBA code for an 'IF' statement that checks for a value within a range of visible columns... (ignoring hidden columns/cells)

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

    VBA compact attributes in less columns

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

    Conditional formatting for multiple loop

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

    is there a way to show a result based on an average

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

    Lookup/match

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

    If/ case statement help please

    ​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...
  14. C

    re-indexing increments

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

    Calculating 'Negative' Time

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

    How to link multiple drop down lists that will lead to True or False outcome.

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

    Stop auto date formating

    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,
  18. J

    Formula to determine the final outcome

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

    Formula Help!

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

    Possible IF Formula required...

    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've detected that you are using an adblocker.

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.
Go back
Back
Top