Thread: Next If Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pjscott pjscott is offline
external usenet poster
 
Posts: 2
Default Next If Help

I'm trying to create a nested if forumla on the following data.

A2 = Mo Service
B2 = Max Annual

Months of Service Maxium Annual
0-59 months 225 hrs.
60-119 months 277.50 hrs.
120-179 months 337.50 hrs.
180-239 months 390 hrs.

If the Max Annual 225 and <60 Mo Service, "Over"

277.5 and <120
337.5 and <180
390 and <240


How do I create a nested if on the above information?

Thanks,

Paul