ExcelBanter - is =if(K25=K36,[SUM(K38:K39)],[SUM(K40:K41)]) ok?

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - is =if(K25=K36,[SUM(K38:K39)],[SUM(K40:K41)]) ok? (https://www.excelbanter.com/excel-programming/326616-%3Dif-k25%3D-k36-%5Bsum-k38-k39-%5D-%5Bsum-k40-k41-%5D-ok.html)

Dell

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.

gareth

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

galimi[_2_]

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.

All times are GMT +1. The time now is 10:53 AM.