Formula Help !

[Guest]

Hi, I have the following formula that works fine but I need to change it..

=IF(AND(YEAR(TODAY())-F123>=1,YEAR(TODAY())-F123<=19),23,28

The values I need to be calculated are as follows: 1 - 14 = 20, 15 - 19 = 22 & 20 and up = 25. I have been unsuccessful in changing this current formula to fit the values I now need

I greatly apprecieate someones help
Thank you
Jen

 

[Andy B]

Hi

Try this version:

=IF(YEAR(TODAY())-F123<=14,20,IF(YEAR(TODAY())-F123<=19,22,25))

--
Andy.

Hi, I have the following formula that works fine but I need to change it...

=IF(AND(YEAR(TODAY())-F123>=1,YEAR(TODAY())-F123<=19),23,28)

The values I need to be calculated are as follows: 1 - 14 = 20, 15 - 19

= 22 & 20 and up = 25. I have been unsuccessful in changing this current
formula to fit the values I now need.

 

[Andy B]

PS
I've assumed (maybe wrongly) that YEAR(TODAY())-F123 will not result in a
negative value.

 

[Peo Sjoblom]

One way

=IF(AND(YEAR(TODAY())-F123>=1,YEAR(TODAY())-F123<15),20,IF(AND(YEAR(TODAY())
-F123>=15,YEAR(TODAY())-F123<=19),22,28))

--

Regards,

Peo Sjoblom

Hi, I have the following formula that works fine but I need to change it...

=IF(AND(YEAR(TODAY())-F123>=1,YEAR(TODAY())-F123<=19),23,28)

The values I need to be calculated are as follows: 1 - 14 = 20, 15 - 19

= 22 & 20 and up = 25. I have been unsuccessful in changing this current
formula to fit the values I now need.

 

[Barbara]

Hi, I have the following formula that works fine but I need to change it...

=IF(AND(YEAR(TODAY())-F123>=1,YEAR(TODAY())-F123<=19),23,28)

The values I need to be calculated are as follows: 1 - 14 = 20, 15 - 19

= 22 & 20 and up = 25. I have been unsuccessful in changing this current
formula to fit the values I now need.

I greatly apprecieate someones help !
Thank you,
Jenn

You can also try with:

=CHOOSE(MATCH(YEAR(TODAY())-F123,{1;15;20}),20,22,25)

Regards
Barbara