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. : 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 59 views

## 1 answer to this question.

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)))
``` • 51,240 points

## 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

## How to check if array is multidimensional or not?

Since the 'second dimension' could be just ...READ MORE

## I am working as a Oracle apps DBA I am planning to change the domain . Is it good if I shift to aws?

I am also working as an Oracle ...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