Comparing and return value based on it

Closed

arun - Oct 18, 2011 at 08:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 18, 2011 at 09:39 AM

Hello,
I've got a table in such a way like
Age Age Cost
16 20 3500

like the above i've 1000 rows
i need the O/p as if the age is between the range of the two ages , it must return the value in cost column

Comparing and return value based on it
If cell contains date then return value ✓ - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum
Excel formula to check if cell contains a date - Excel Forum
Zuma return - Download - Puzzle
Instagram account based in wrong country - Instagram Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Oct 18, 2011 at 09:39 AM

Hi Arun,

What is O/p and how to determine the value in the cost column?

Have no idea what you want to achieve.

Best regards,
Trowa

Similar discussions

help me to add particular cells

WOW equipment return

If a cell contains any text then add a value

If cell = date return yes or no.

Fill adjacent cell with number from text answer

Similar discussions

Subscribe To Our Newsletter!