Complicated formula help

[Guest]

This is a tough one for me, can someone show me how to create a forumula to do the following or if it's even possible...

if cell a1 is before 10 and if cell a2 is before 21 and cell a3 is before 1994, then if cell a3 is between 1 and 60 days = 0, between 60 and 1 year = 7, between 1 year and 3 years = 10, between 3 and 5 years = 15, between 5 and 10 years = 20, between 10 and 15 years = 25 and more that 15 years = 3

and

if cell a1 is after 10 and if cell a2 is after 21 and cell a3 is after 1994, then 30 days after cell a3=1 (retroactive to cell a3) then plus 1 every month after up until 12. if 1 year from cell a3 then = 12 for beginning of next calendar year not to exceed 60 days

 

[Ron Rosenfeld]

This is a tough one for me, can someone show me how to create a forumula to do the following or if it's even possible...:

if cell a1 is before 10 and if cell a2 is before 21 and cell a3 is before 1994, then if cell a3 is between 1 and 60 days = 0, between 60 and 1 year = 7, between 1 year and 3 years = 10, between 3 and 5 years = 15, between 5 and 10 years = 20, between 10 and 15 years = 25 and more that 15 years = 30

and

if cell a1 is after 10 and if cell a2 is after 21 and cell a3 is after 1994, then 30 days after cell a3=1 (retroactive to cell a3) then plus 1 every month after up until 12. if 1 year from cell a3 then = 12 for beginning of next calendar year not to exceed 60 days.

You probably won't get useful information until you can clearly express your
problem.

What do you mean by "before"?
What kind of data are you using? Although the numbers you posted are integers,
in the context they appear to represent some kind of date or time.

How do you differentiate the value in A3 from representing days vs years?

Your last sentence is completely incomprehensible to me.


--ron

 

[Jerry W. Lewis]

Your question is unclear. In your explanation, cell a3 seems to
simultaneously contain a year and a relatively few number of days from
some unspecified reference.

Multiple conditions can be specified as follows
(A1<10)*(A2<21)*(A3<1994)
Here * functions like a logical AND (+ would function like a logical OR)

Jerry

This is a tough one for me, can someone show me how to create a forumula

to do the following or if it's even possible...:

if cell a1 is before 10 and if cell a2 is before 21 and cell a3 is before

1994, then if cell a3 is between 1 and 60 days = 0, between 60 and 1 year

= 7, between 1 year and 3 years = 10, between 3 and 5 years = 15, between

5 and 10 years = 20, between 10 and 15 years = 25 and more that 15 years

= 30

and

if cell a1 is after 10 and if cell a2 is after 21 and cell a3 is after

1994, then 30 days after cell a3=1 (retroactive to cell a3) then plus 1