View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default can I add 4/5 and1/2 to get 6/7 as in 4 of 5 + 1 of 2 and get6 o

On 2/4/2010 9:49 AM, 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?

I realize it's not what you asked, but couldn't you have the users enter
the data in two columns: 4 <right arrow 5
instead of 4/5? Much easier to keep track of without long formulas.

Bill