How can i add cells if condition is met

0 votes
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 by Kithuzzz
• 27,740 points
59 views

1 answer to this question.

0 votes

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

enter image description here

answered Nov 24, 2022 by narikkadan
• 51,240 points

Related Questions In Others

0 votes
1 answer

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

answered 6 days ago in Others by narikkadan
• 51,240 points
36 views
0 votes
1 answer

How to check if array is multidimensional or not?

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

answered Nov 5, 2018 in Others by DataKing99
• 8,240 points
4,251 views
0 votes
0 answers

How can i solve NoClassdeffoundError on my mobile?

Oct 15, 2019 in Others by SolomonTS
• 120 points
230 views
0 votes
1 answer
0 votes
1 answer

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

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,640 points
206 views
0 votes
1 answer

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

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

answered Feb 16, 2022 in Others by Edureka
• 13,640 points
370 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

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

Feb 17, 2022 in Others by Edureka
• 13,640 points
168 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18, 2022 in Others by gaurav
• 22,940 points
148 views
0 votes
1 answer

Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

answered Nov 11, 2022 in Others by narikkadan
• 51,240 points
135 views
0 votes
1 answer

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

answered Oct 24, 2022 in Others by narikkadan
• 51,240 points
140 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP