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" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>