ブランド	普及品	高級品		
現行価格(円)	600	800		
購入意向率	0.25	0.3		

	購入意向率		価格弾力性	
価格(円)	普及品	高級品	普及品	高級品
400	0.35	0.28	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))
500	0.3	0.33	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))
600	0.25	0.35	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))
700	0.2	0.33	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))
800	0.14	0.3	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))
900	0.09	0.29	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))
1000	0.04	0.25	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))
1100	0.02	0.2	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))
1200	0	0.18	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))	=IF(RC1=R2C[-2],"-",-((RC[-2]-R3C[-2])/R3C[-2])/((RC1-R2C[-2])/R2C[-2]))