Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statment across Multiple Sheets
I am currently trying to update a couple workbooks and would like to combine them into one workbook with multiple sheet. What I have: One sheet is a proposal sheet and I have four other sheets that depend on what the average ticket is of the proposal as to which commission calculators I use. What I would like to happen is that when the average ticket on the proposal sheet is u <15.00 I would like all the proceeding information about that proposal to go into the <15.00 average ticket commission calculator. I would like for this to happen for a range of average tickets that include <15, 15-25 and 25.00. I hope this is possible at it would cut out many mistakes on my sales team from them using the wrong commission calculator. Thanks is advance, JD -- jdeer0618 ------------------------------------------------------------------------ jdeer0618's Profile: http://www.excelforum.com/member.php...o&userid=34553 View this thread: http://www.excelforum.com/showthread...hreadid=543177 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statment across Multiple Sheets
I am sure what you are trying to do is possible but you will need to be
clearer about what it is you want to do. You haven't explained what you mean ticket and what you you want to go to calculate based on this ticket. Provide some more info and I am sure someone will solve your problem. Ian "jdeer0618" wrote: I am currently trying to update a couple workbooks and would like to combine them into one workbook with multiple sheet. What I have: One sheet is a proposal sheet and I have four other sheets that depend on what the average ticket is of the proposal as to which commission calculators I use. What I would like to happen is that when the average ticket on the proposal sheet is u <15.00 I would like all the proceeding information about that proposal to go into the <15.00 average ticket commission calculator. I would like for this to happen for a range of average tickets that include <15, 15-25 and 25.00. I hope this is possible at it would cut out many mistakes on my sales team from them using the wrong commission calculator. Thanks is advance, JD -- jdeer0618 ------------------------------------------------------------------------ jdeer0618's Profile: http://www.excelforum.com/member.php...o&userid=34553 View this thread: http://www.excelforum.com/showthread...hreadid=543177 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
Select Multiple sheets | Excel Discussion (Misc queries) | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |