関数式の作成 |
|
お買い上げ個数 |
|
セルD |
|
14 |
=IF(ISERR(($F8-$F26)>=D12),"個数が多い",IF(($F8-$F26)>=D12,"◆","")) |
|
16 |
=D12*D15 |
|
セルF |
|
14 |
=IF(ISERR(($F8-$F26)>=F12),"個数が多い",IF(($F8-$F26)>=F12,"◆","")) |
|
16 |
=F12*F15 |
|
セルH |
|
14 |
=IF(ISERR(($F8-$F26)>=H12),"個数が多い",IF(($F8-$F26)>=H12,"◆","")) |
|
16 |
=H12*H15 |
|
|
商品をお買い上げ個数表示します |
|
セルJ |
セルL |
9 |
=D12 |
=IF(G29<>"",REPT(" "&
K9,D15),"") |
11 |
=F12 |
=IF(G29<>"",REPT("
"&K11,F15),"") |
13 |
=H12 |
=IF(G29<>"",REPT("
"&K13,H15),"") |
|
入金から商品をお買い上げ金額を引きお釣銭を表示します |
|
セルF |
|
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) |
| |