Hi

I have a cell that generates an age in years from a date of birth in
another cell. 1, 2, 3 etc,

The age is displayed in L7

In another cell I need one of three prices based upon that age in
L7

Under age 2 should return a price of 3.50
Aged 2 should return a price of 3.20
And 3 and above should returna price of 2.8

I have tried playing with the IF function but just cannot get it to
work

Hope you can help. Thanks in anticipation

=IF(L7<2,3.5,IF(L7=2,3.2,2.8))

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


" wrote:

Hi

I have a cell that generates an age in years from a date of birth in
another cell. 1, 2, 3 etc,

The age is displayed in L7

In another cell I need one of three prices based upon that age in
L7

Under age 2 should return a price of 3.50
Aged 2 should return a price of 3.20
And 3 and above should returna price of 2.8

I have tried playing with the IF function but just cannot get it to
work

Hope you can help. Thanks in anticipation

=IF(I7<2,"3.5",IF(I7=2,3.2,IF(I7=3,2.8)))

The above will give the answer you want but are you sure your logic is
correct. What happens between 2 and 3?

" wrote:

Hi

I have a cell that generates an age in years from a date of birth in
another cell. 1, 2, 3 etc,

The age is displayed in L7

In another cell I need one of three prices based upon that age in
L7

Under age 2 should return a price of 3.50
Aged 2 should return a price of 3.20
And 3 and above should returna price of 2.8

I have tried playing with the IF function but just cannot get it to
work

Hope you can help. Thanks in anticipation

try
=if(l7=3,2.8,if(l7=2,3.20,if(l70,3.50,"")))

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
Hi

I have a cell that generates an age in years from a date of birth in
another cell. 1, 2, 3 etc,

The age is displayed in L7

In another cell I need one of three prices based upon that age in
L7

Under age 2 should return a price of 3.50
Aged 2 should return a price of 3.20
And 3 and above should returna price of 2.8

I have tried playing with the IF function but just cannot get it to
work

Hope you can help. Thanks in anticipation

=LOOKUP(L7,{0,3.5;2,3.2;3,2.8})

On Feb 6, 2:19 pm, wrote:
Hi

I have a cell that generates an age in years from a date of birth in
another cell. 1, 2, 3 etc,

The age is displayed in L7

In another cell I need one of three prices based upon that age in
L7

Under age 2 should return a price of 3.50
Aged 2 should return a price of 3.20
And 3 and above should returna price of 2.8

I have tried playing with the IF function but just cannot get it to
work

Hope you can help. Thanks in anticipation

one way:

=IF(L7<2, 3.5, IF(L7<3, 3.2, 2.8)

another:

=LOOKUP(L7, {0, 2, 3}, {3.5, 3.2, 2.8})


In article .com,
wrote:

Hi

I have a cell that generates an age in years from a date of birth in
another cell. 1, 2, 3 etc,

The age is displayed in L7

In another cell I need one of three prices based upon that age in
L7

Under age 2 should return a price of 3.50
Aged 2 should return a price of 3.20
And 3 and above should returna price of 2.8

I have tried playing with the IF function but just cannot get it to
work

Hope you can help. Thanks in anticipation

Assuming the OP wanted numbers rather than text, the 3.5 should not be
in quotes. If the OP wanted text instead, the other values should be in
quotes.

In article ,
Mike wrote:

=IF(I7<2,"3.5",IF(I7=2,3.2,IF(I7=3,2.8)))

The above will give the answer you want but are you sure your logic is
correct. What happens between 2 and 3?