View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jim@excelsecurity.co.uk is offline
external usenet poster
 
Posts: 1
Default The IF function but with 3 values

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