Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
Lookup Function Referencing cells, not text values | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions |