I just can't figure this one out
 

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?

Hi

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

Cheers
JulieD


"Barb1" wrote in message
...
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?