Thread: is =if(K25=K36,[SUM(K38:K39)],[SUM(K40:K41)]) ok?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
galimi[_2_] galimi[_2_] is offline
external usenet poster
  
Posts: 65
Default 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 With QuoteReply With Quote