Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |