Thread: The goal is 5 per 100 transactions, how do I write formula for %
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 The goal is 5 per 100 transactions, how do I write formula for %
In A1 put 100
In A2 put 5
In A3 put =A2*20/A1 and format as percentage
--
Gary's Student


"andy3468" wrote:

I'm new to Excel and I'm trying to write this formula; please help!

For example:

100 Transactions done today
5 subscriptions
=100%

andy
Reply With QuoteReply With Quote