Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default how to combine an IF Function with a lookup function to determine

I have two charts. I have to combine an IF function with a lookup fuction to
determine the value in the last column of the first chart.
The value is to determine minutes allowed based on age and gender.
The time varies by gender. That information is in the second chart.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default how to combine an IF Function with a lookup function to determine

" wrote
in message ...
I have two charts. I have to combine an IF function with a lookup fuction
to
determine the value in the last column of the first chart.
The value is to determine minutes allowed based on age and gender.
The time varies by gender. That information is in the second chart.

================================
take a look at

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

HTH,

ryanb.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
LOOKUP FUNCTION Anna Excel Worksheet Functions 3 March 9th 06 03:04 AM
Need help on LOOKUP function..please Beblessed New Users to Excel 4 March 3rd 06 08:47 AM
LOOKUP function haroldhagar Excel Worksheet Functions 2 August 6th 05 07:38 PM
Pivot table doing a lookup without using the lookup function? NGASGELI Excel Discussion (Misc queries) 0 August 2nd 05 05:08 AM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM


All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"