How to use two functions in one cell

I'm using Excel 2010 and I'm trying to do the following

  • For IT Changes in different locations, I'm trying to find the % of  "successful" changes in location "NewYork". I have a column which divides success/failures. 
  • The data is in the same file using different spreadsheets

EX:

Page Name: By location

  [column headings]               NewJersey        NewYork      Conn

% of successful                                  [formula]              [formula]         [formula] 

Page Name: Aug

Date             Location        Risk Level        Status

7/20/2015    NewJersey      1                     Successful

7/30/2015    NewYork         1                     Successful

7/30/2015    NewYork         1                     Successful

I hope this was enough information. Which functions can I use? Thank you

July 30th, 2015 11:13pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics