I am trying to automate an avalability report for uptime and need to calculate the recorded downtime as a percent of avalable time over the last month. I created a nested IF function where IF Jan,744,(IF FEB,672,(IF MAR,744,(IF APR,720,0))) etc., however excel ( MS OFFICE 2000 ) only alows for 7 nested functions, and using this method I would require 12. If anyone has a workaround or another technique I would be greatfull to know.
Thanks in Advance
BigandFat
Thanks in Advance
BigandFat