|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 24th, 2010, 05:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. 
|
|
#2
May 24th, 2010, 05:54 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)
|
|
#3
May 24th, 2010, 07:15 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
