ExcelBanter - if true, if not nested if funcion

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - if true, if not nested if funcion (https://www.excelbanter.com/excel-worksheet-functions/264403-if-true-if-not-nested-if-funcion.html)

Cali

if true, if not nested if funcion

Having some trouble figuring out a formula. Hope someone can help!
This is going to go into Cell B10.

If cell b7 is =equal or greater than the value in B12 only sum B6+B8+B9;
however, is cell b7 is less than the value in B12 sum b6+B7+B8+B9. How would
i write this as a formula for I am doing something wrong.

Glenn

if true, if not nested if funcion

Cali wrote:
Having some trouble figuring out a formula. Hope someone can help!
This is going to go into Cell B10.

If cell b7 is =equal or greater than the value in B12 only sum B6+B8+B9;
however, is cell b7 is less than the value in B12 sum b6+B7+B8+B9. How would
i write this as a formula for I am doing something wrong.

One of many ways:

=SUM(B6:B9)-IF(B7=B12,B7,0)

Cali

if true, if not nested if funcion

Thank you Glenn.

"Glenn" wrote:

Cali wrote:
Having some trouble figuring out a formula. Hope someone can help!
This is going to go into Cell B10.

If cell b7 is =equal or greater than the value in B12 only sum B6+B8+B9;
however, is cell b7 is less than the value in B12 sum b6+B7+B8+B9. How would
i write this as a formula for I am doing something wrong.

One of many ways:

=SUM(B6:B9)-IF(B7=B12,B7,0)
.

All times are GMT +1. The time now is 11:17 PM.