IF Statment across Multiple Sheets

  • Thread starter Thread starter jdeer0618
  • Start date Start date
J

jdeer0618

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average a group of numbers within an date range. 4
how to use tier system 9
Comparing 2 worksheets in Excel 2007 1
Average across worksheets ignoring zero 2
Can Excel Rtrn a Value by Referencing Multiple Rows and Columns 2
Formatting question with Round 3
Formula across multiple sheets 6
Count based on multiple criteria 2

Back
Top