ブランド	高級品					
案	案2					
広告費(百万円)	150	300	500	1000	1500	2000
広告効果率	0.03	0.05	0.1	0.13	0.16	0.2
広告実施後の購入意向率	=(1+R[-1]C)*IF(R[-4]C2=値上!R[-4]C2,HLOOKUP(R[-3]C2,値上!R[5]C2:R[8]C5,4),HLOOKUP(R[-3]C2,値上!R[5]C6:R[8]C9,4))	=(1+R[-1]C)*IF(R[-4]C2=値上!R[-4]C2,HLOOKUP(R[-3]C2,値上!R[5]C2:R[8]C5,4),HLOOKUP(R[-3]C2,値上!R[5]C6:R[8]C9,4))	=(1+R[-1]C)*IF(R[-4]C2=値上!R[-4]C2,HLOOKUP(R[-3]C2,値上!R[5]C2:R[8]C5,4),HLOOKUP(R[-3]C2,値上!R[5]C6:R[8]C9,4))	=(1+R[-1]C)*IF(R[-4]C2=値上!R[-4]C2,HLOOKUP(R[-3]C2,値上!R[5]C2:R[8]C5,4),HLOOKUP(R[-3]C2,値上!R[5]C6:R[8]C9,4))	=(1+R[-1]C)*IF(R[-4]C2=値上!R[-4]C2,HLOOKUP(R[-3]C2,値上!R[5]C2:R[8]C5,4),HLOOKUP(R[-3]C2,値上!R[5]C6:R[8]C9,4))	=(1+R[-1]C)*IF(R[-4]C2=値上!R[-4]C2,HLOOKUP(R[-3]C2,値上!R[5]C2:R[8]C5,4),HLOOKUP(R[-3]C2,値上!R[5]C6:R[8]C9,4))
売上数量(百万本)	=IF(R[-5]C2=値上!R[-5]C2,値上!R[-2]C2*R[-1]C,値上!R[-2]C3*R[-1]C)	=IF(R[-5]C2=値上!R[-5]C2,値上!R[-2]C2*R[-1]C,値上!R[-2]C3*R[-1]C)	=IF(R[-5]C2=値上!R[-5]C2,値上!R[-2]C2*R[-1]C,値上!R[-2]C3*R[-1]C)	=IF(R[-5]C2=値上!R[-5]C2,値上!R[-2]C2*R[-1]C,値上!R[-2]C3*R[-1]C)	=IF(R[-5]C2=値上!R[-5]C2,値上!R[-2]C2*R[-1]C,値上!R[-2]C3*R[-1]C)	=IF(R[-5]C2=値上!R[-5]C2,値上!R[-2]C2*R[-1]C,値上!R[-2]C3*R[-1]C)
売上金額(百万円)	=IF(R[-6]C2=値上!R[-6]C2,R[-1]C*(値上!R[-4]C2+VLOOKUP(R[-5]C2,値上!R[-5]C5:R[-2]C7,値上!R[-4]C9)),R[-1]C*(値上!R[-4]C3+VLOOKUP(R[-5]C2,値上!R[-5]C5:R[-2]C7,値上!R[-4]C9)))	=IF(R[-6]C2=値上!R[-6]C2,R[-1]C*(値上!R[-4]C2+VLOOKUP(R[-5]C2,値上!R[-5]C5:R[-2]C7,値上!R[-4]C9)),R[-1]C*(値上!R[-4]C3+VLOOKUP(R[-5]C2,値上!R[-5]C5:R[-2]C7,値上!R[-4]C9)))	=IF(R[-6]C2=値上!R[-6]C2,R[-1]C*(値上!R[-4]C2+VLOOKUP(R[-5]C2,値上!R[-5]C5:R[-2]C7,値上!R[-4]C9)),R[-1]C*(値上!R[-4]C3+VLOOKUP(R[-5]C2,値上!R[-5]C5:R[-2]C7,値上!R[-4]C9)))	=IF(R[-6]C2=値上!R[-6]C2,R[-1]C*(値上!R[-4]C2+VLOOKUP(R[-5]C2,値上!R[-5]C5:R[-2]C7,値上!R[-4]C9)),R[-1]C*(値上!R[-4]C3+VLOOKUP(R[-5]C2,値上!R[-5]C5:R[-2]C7,値上!R[-4]C9)))	=IF(R[-6]C2=値上!R[-6]C2,R[-1]C*(値上!R[-4]C2+VLOOKUP(R[-5]C2,値上!R[-5]C5:R[-2]C7,値上!R[-4]C9)),R[-1]C*(値上!R[-4]C3+VLOOKUP(R[-5]C2,値上!R[-5]C5:R[-2]C7,値上!R[-4]C9)))	=IF(R[-6]C2=値上!R[-6]C2,R[-1]C*(値上!R[-4]C2+VLOOKUP(R[-5]C2,値上!R[-5]C5:R[-2]C7,値上!R[-4]C9)),R[-1]C*(値上!R[-4]C3+VLOOKUP(R[-5]C2,値上!R[-5]C5:R[-2]C7,値上!R[-4]C9)))
製造変動費(百万円)	=IF(R[-7]C2=値上!R[-7]C2,(値上!R[-2]C2*HLOOKUP(R[-6]C2,値上!R[2]C2:R[3]C5,2)+値上!R[-1]C2)*R[-2]C,(値上!R[-2]C3*HLOOKUP(R[-6]C2,値上!R[2]C6:R[3]C9,2)+値上!R[-1]C3)*R[-2]C)	=IF(R[-7]C2=値上!R[-7]C2,(値上!R[-2]C2*HLOOKUP(R[-6]C2,値上!R[2]C2:R[3]C5,2)+値上!R[-1]C2)*R[-2]C,(値上!R[-2]C3*HLOOKUP(R[-6]C2,値上!R[2]C6:R[3]C9,2)+値上!R[-1]C3)*R[-2]C)	=IF(R[-7]C2=値上!R[-7]C2,(値上!R[-2]C2*HLOOKUP(R[-6]C2,値上!R[2]C2:R[3]C5,2)+値上!R[-1]C2)*R[-2]C,(値上!R[-2]C3*HLOOKUP(R[-6]C2,値上!R[2]C6:R[3]C9,2)+値上!R[-1]C3)*R[-2]C)	=IF(R[-7]C2=値上!R[-7]C2,(値上!R[-2]C2*HLOOKUP(R[-6]C2,値上!R[2]C2:R[3]C5,2)+値上!R[-1]C2)*R[-2]C,(値上!R[-2]C3*HLOOKUP(R[-6]C2,値上!R[2]C6:R[3]C9,2)+値上!R[-1]C3)*R[-2]C)	=IF(R[-7]C2=値上!R[-7]C2,(値上!R[-2]C2*HLOOKUP(R[-6]C2,値上!R[2]C2:R[3]C5,2)+値上!R[-1]C2)*R[-2]C,(値上!R[-2]C3*HLOOKUP(R[-6]C2,値上!R[2]C6:R[3]C9,2)+値上!R[-1]C3)*R[-2]C)	=IF(R[-7]C2=値上!R[-7]C2,(値上!R[-2]C2*HLOOKUP(R[-6]C2,値上!R[2]C2:R[3]C5,2)+値上!R[-1]C2)*R[-2]C,(値上!R[-2]C3*HLOOKUP(R[-6]C2,値上!R[2]C6:R[3]C9,2)+値上!R[-1]C3)*R[-2]C)
利益(百万円)	=IF(R[-8]C2=値上!R[-8]C2,R[-2]C-R[-1]C-値上!R[-4]C2-R[-2]C*値上!R[-1]C2-R[-6]C,R[-2]C-R[-1]C-値上!R[-4]C3-R[-2]C*値上!R[-1]C3-R[-6]C)	=IF(R[-8]C2=値上!R[-8]C2,R[-2]C-R[-1]C-値上!R[-4]C2-R[-2]C*値上!R[-1]C2-R[-6]C,R[-2]C-R[-1]C-値上!R[-4]C3-R[-2]C*値上!R[-1]C3-R[-6]C)	=IF(R[-8]C2=値上!R[-8]C2,R[-2]C-R[-1]C-値上!R[-4]C2-R[-2]C*値上!R[-1]C2-R[-6]C,R[-2]C-R[-1]C-値上!R[-4]C3-R[-2]C*値上!R[-1]C3-R[-6]C)	=IF(R[-8]C2=値上!R[-8]C2,R[-2]C-R[-1]C-値上!R[-4]C2-R[-2]C*値上!R[-1]C2-R[-6]C,R[-2]C-R[-1]C-値上!R[-4]C3-R[-2]C*値上!R[-1]C3-R[-6]C)	=IF(R[-8]C2=値上!R[-8]C2,R[-2]C-R[-1]C-値上!R[-4]C2-R[-2]C*値上!R[-1]C2-R[-6]C,R[-2]C-R[-1]C-値上!R[-4]C3-R[-2]C*値上!R[-1]C3-R[-6]C)	=IF(R[-8]C2=値上!R[-8]C2,R[-2]C-R[-1]C-値上!R[-4]C2-R[-2]C*値上!R[-1]C2-R[-6]C,R[-2]C-R[-1]C-値上!R[-4]C3-R[-2]C*値上!R[-1]C3-R[-6]C)