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?
 
Ad

Advertisements

J

JulieD

Hi

one way
=(IF(D1="T5910",.02,IF(D1="S4800",.03,0))+.03)*C1

Cheers
JulieD
 

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

Top