Thread: How Do I create a formula for the percentage below?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How Do I create a formula for the percentage below?
Try this:

=(B20-22.74)/B19

--
Gary''s Student - gsnu200903


"Anita" wrote:

I am trying to type a formula to get a percentage for cells B19 and B20 with
the following numbers type in these two cells - B19 - 70 and B20 - 34.5. I
actually have the answer (16.8%) but need to know the formula that would come
up with this number. Any help is appreciated. Thanks
Reply With QuoteReply With Quote