Write an excel nested if statement use the value

“Write an excel nested if statement that will Use the value in cell A1 to determine which 2 cell values in column c that it falls between and enter the lower amount. So if a1 is greater than the value in c1 but less than the value of c2 the formula should continue until it reaches the true in between point. In this example the formula should see that cell a1 is greater than cell c3 but less than cell c4 and therefore insert the value in cell4 otherwise say “no value found”

Leave a Reply

Your email address will not be published. Required fields are marked *