Thread: can I add 4/5 and1/2 to get 6/7 as in 4 of 5 + 1 of 2 and get 6 o
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default can I add 4/5 and1/2 to get 6/7 as in 4 of 5 + 1 of 2 and get 6 o
Hi
try

=TRIM(LEFT(E2,FIND("/",E2)-1))+TRIM(LEFT(F2,FIND("/",F2)-1))&"/"&=TRIM(RIGHT(E2,FIND("/",E2)-1))+TRIM(RIGHT(F2,FIND("/",F2)-1))

"kschmoll" wrote:

I am trying to keep a running total by month of sales vs calls and the data
is entered as 4/5, etc. Is this possible in Excel?
Reply With QuoteReply With Quote