| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate 20% of a total figure | Excel Worksheet Functions | |||
| how to type a minues figure | New Users to Excel | |||
| Timesheet - I can't figure out how to do this! | Excel Worksheet Functions | |||
| excel to figure miles per gallon | New Users to Excel | |||
| How to figure roots in Excel? | Excel Worksheet Functions | |||
Linear Mode
