1价电量1-230:每度电价格是0.49832价电量231-420:每度电价格是0.54833价电量 >=421:每度电价格是0.7983请帮我写个公式,谢谢!
公式为:
=SUMPRODUCT(TEXT(A1-{0,230,420},"0;!0")*{0.4983,0.05,0.25})
如图所示: