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

Reply With QuoteReply With Quote