| 関数式の作成 |
| |
お買い上げ個数 |
|
| セルＤ |
|
| 14 |
=IF(ISERR(($F8-$F26)>=D12),"個数が多い",IF(($F8-$F26)>=D12,"◆","")) |
|
| 16 |
=D12*D15 |
|
| セルＦ |
|
| 14 |
=IF(ISERR(($F8-$F26)>=F12),"個数が多い",IF(($F8-$F26)>=F12,"◆","")) |
|
| 16 |
=F12*F15 |
|
| セルＨ |
|
| 14 |
=IF(ISERR(($F8-$F26)>=H12),"個数が多い",IF(($F8-$F26)>=H12,"◆","")) |
|
| 16 |
=H12*H15 |
|
| |
商品をお買い上げ個数表示します |
|
| セルＪ |
セルＬ |
| 9 |
=D12 |
=IF(G29<>"",REPT(" "&
K9,D15),"") |
| 11 |
=F12 |
=IF(G29<>"",REPT("
"&K11,F15),"") |
| 13 |
=H12 |
=IF(G29<>"",REPT("
"&K13,H15),"") |
| |
入金から商品をお買い上げ金額を引きお釣銭を表示します |
|
| セルＦ |
|
| 22 |
=IF(OR(MOD(D12,10),MOD(F12,10),MOD(H12,10)),F8,(F8-MOD(F8,10))) |
|
| 26 |
=IF(SUM(D16:H16)>F22,"入金不足",SUM(D16:H16)) |
|
| 33 |
=IF(OR(SUM(D16:H16)>F22,G29=""),MOD(F8,10),F8-F26) |
| |
