Home |
Search |
Today's Posts |
#1
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
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
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) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
offset, transpose funcion | Excel Worksheet Functions | |||
INSERTAR FUNCION MES | Excel Worksheet Functions | |||
If funcion on big formula | Excel Worksheet Functions | |||
Is there any funcion like a @maxif or @minif? | Excel Worksheet Functions | |||
how do see add-in a funcion belongs to | Excel Discussion (Misc queries) |