| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is =if(K25=K36,[SUM(K38:K39)],[SUM(K40:K41)]) ok?
is the function =if(K25=K36,[SUM(K38:K39)],[SUM(K40:K41)]) ok?
Its giving me error ,K40 and K39 have further function values.K40=k25+(k36)/2 and k39=k36+(k25)/2 k41 and k38 are empty cells. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is =if(K25=K36,[SUM(K38:K39)],[SUM(K40:K41)]) ok?
=IF(K25=K36,SUM(K38:K39),SUM(K40:K41))
gareth -----Original Message----- is the function =if(K25=K36,[SUM(K38:K39)],[SUM (K40:K41)]) ok? Its giving me error ,K40 and K39 have further function values.K40=k25+(k36)/2 and k39=k36+(k25)/2 k41 and k38 are empty cells. . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is =if(K25=K36,[SUM(K38:K39)],[SUM(K40:K41)]) ok?
Remove the brackets
=if(K25=K36,SUM(K38:K39),SUM(K40:K41)) http://HelpExcel.com "dell" wrote: is the function =if(K25=K36,[SUM(K38:K39)],[SUM(K40:K41)]) ok? Its giving me error ,K40 and K39 have further function values.K40=k25+(k36)/2 and k39=k36+(k25)/2 k41 and k38 are empty cells. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
