View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Drew Drew is offline
external usenet poster
 
Posts: 39
Default I'm new to Excel,

and am self taught with minimal experience. I was wondering if someone knew
of a better way to perform this formula:

=IF(SUM(E5/F5<95),IF(SUM(E5+100)/(F5+1)=95,1,IF(SUM(E5+200)/(F5+2)=95,2,IF(SUM(E5+300)/(F5+3)=95,3,IF(SUM(E5+400)/(F5+4)=95,4,IF(SUM(E5+500)/(F5+5)=95,5,IF(SUM(E5+600)/(F5+6)=95,6,GET TO WORK)))))),0)


What I'd like to do is remove the ',get to work' statement and add more if
funtions but of course excel won't allw me to nest more than 7. Is there
another function I could be using?? I do not know macros, YET, so while I'm
not against it, I would like to use an entry I could explain to someone.