if true, if not nested if funcion

C

Cali

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.
 
G

Glenn

Cali said:
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.
Click to expand...

One of many ways:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

correcting #value! problem 4
Payment calculation 1
Help with a formula (calculating totals based on individual percentages 7
vlookup error 3
Trouble trying to do a 'Count IF' 2
Complicated IF statement - desperately need some help 4
Alpha sorting (with a twist...?) 3
IF formula returns FALSE 1

Top