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

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