View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default How do I solve for x?

M2=1000000-SUM(A2:L2)
--
Gary''s Student
gsnu200702


"JoAnna" wrote:

I have a spreadsheet where O=the sum of A2 through M2. How do I solve for M2
when O2 must = $1mil or less?
Much appreciative of any help!