Next If Help

P

pjscott

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
 
R

Ron@Buy

Paul not clear what complete result you are trying to achieve:
Presumably these are hours -
277.5 and <120
337.5 and <180
390 and <240
But you give no indication what result you are expecting if the above
statements are true or what you expect if they are false !!
Also so that a formula can be crated relevant to your worksheet, in which
colums/rows are your data held. Presumably you have a column of names
alongside a column containing the months of service (and the months of
service column contains formulae relative to 'today' so that the 'months of
service' is updated daily)?
 
P

pjscott

The formula would be something like:

If the B2>225 and A1<60, If B2 >277.5 and A2 <120, If B2 >337.5 and A2<180,
If B2 >390 and A2<240

If B2 is > then A1 the reply would be something like "over".

A blank cell would be ok if B2 is < A1.

Sorry for the confussion,

Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top