What should I do if the condition is true? I'm using a condition that says to display cell value C if it is larger than 5 and equal to 10, to add cell values C and D if it is greater than 10 and equal to 15, and to add cell values C, D, and E if it is greater than 15. I still have a question. I need to figure out the amount depending on the days using the table below. [1]: https://i.stack.imgur.com/ZTWcQ.png cell Cell A displays 10000 for days 8 through 14, B+C for days 15 through 21, and D+C+B for days 21 and beyond. Every week that passes beyond 35 days should add extra values to cell D. For instance, the computation for 35 days should be B+C+D+D, and so forth.
Nov 24, 2022 in Others 575 views

Both the AND function and nested if statements can be used to accomplish this.

To compare the values, you will use the and(statement1,statement2) operator, for instance: value>5,value<10

If the condition is false, add another if statement to check for more results. Use this in the if(condition,ifTrueValue,ifFalseValue).

You can use the following function in the cell you want the result in

```=IF(AND(B9>5,B9<=10),C9,IF(AND(B9>10,B9<=15),C9+D9,IF(B9>15,C9+D9+E9,0)))
```

• 63,700 points

How can I verify if a column is only decimal using Power Query M formula?

Try this: = Table.ReplaceValue(#"Changed Type",each [Column4], each ...READ MORE

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

Excel - return a value only if a condition is met via VBA

You could use IIf() DestSheet.Cells(erow, 9).Value = IIf(newuplift = ...READ MORE

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE