This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Hours / Feature times Cost / Hours + Base Hours times Base Cost / Hour all multiplied by the static Cost Multiplier field. ) , a static field labeled Cost Multiplier (a percentage input). F1 = =IF( B1>=10, 60,IF(B1>=5,45,25)) F2 = =(B2*B1)+E1 F3 = =(( B2*B1*B3) +(E1*E2)) * $E$4 A B C D E 1 Item Cost On Hand Reta il Make More ? 2 Muffi n $.50 23 F1 F2 3 You need fields and labels for Item (a string input), Cost (a currency input), On Hand (a number input), Retail (F1; cost x 1.5) and Make More? (F2; IF(C2<12,"yes","no")) Enter the data as appropriate for the following item: a muffin, the Cost is $.50 and the On Hand is 23...
View Full Document
- Spring '08
- Microeconomics, Trigraph, F3, number input, otal Featu res