I just can't figure this one out

G

Guest

How do I do the formula if I want the total to reflect the price per copy of
whichever copier I used, either the T5910 or the S4900. The sample is below.


T5910 = .02

S4800 = .03


A B C
D E
# of Originals # of Copies # of Impressions Copier Paper

5 10 A1*B1
T5910 .03

Total = C1*((either .02 or .03)+.03))
So, number of impressions times the sum of {the cost per copy of whichever
copier is in D + .03} Can anyone help?
 

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

SUMIF using dates in cells 5
Excel 2002 : How to sum by month and year ? 3
Summing related cell values and returning total to summary 2
Validation List with 2 criterias 1
Conditional formatting.. how do I copy cells? 2
SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria 2
Using a conditional function to sum the difference between two col 3
Grouping Totals 1

Top