Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"