Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to subtract whole #s but not fractions..
I'm trying to keep a over/shortage cash tally where all positive figures are
added but only whole negative numbers are subtracted (0.99 and under are not subtracted) from the running tally. Example: This is how it looks now DATE O/S Where BAL PAID BALANCE 4/1 $0.00 g $0.00 $0.00 4/2 ($0.50) g ($0.50) ($0.50) 4/3 $0.00 g ($0.50) ($0.50) 4/4 ($0.30) g ($0.80) ($0.80) 4/5 ($0.91) g ($1.71) ($1.71) 4/6 $6.35 c $4.64 $4.64 4/8 ($21.51) g ($16.87) $10.00 ($6.87) 4/8 ($0.10) c ($6.97) ($6.97) 4/9 $5.10 g ($1.87) ($1.87) 4/10 $0.09 g ($1.78) ($1.78) 4/11 ($3.65) c ($5.43) $3.00 ($2.43) This is how it should auto-calculate: DATE O/S Where BAL PAID BALANCE 4/1 $0.00 g $0.00 $0.00 4/2 ($0.50) g $0.00 $0.00 4/3 $0.00 g $0.00 $0.00 4/4 ($0.30) g $0.00 $0.00 4/5 ($0.91) g $0.00 $0.00 4/6 $6.35 c $6.35 $6.35 4/8 ($21.51) g ($15.16) $10.00 ($5.16) 4/8 ($0.10) c ($5.16) ($5.16) 4/9 $5.10 g ($0.06) ($0.06) 4/10 $0.09 g ($0.03) ($0.03) 4/11 ($3.65) c ($3.62) $3.00 ($0.62) I tried to come up with an "IF" type formula but nothing I tried would work. Does anybody know how to do this type of formula? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fractions | Excel Discussion (Misc queries) | |||
fractions | Excel Worksheet Functions | |||
Fractions | Excel Discussion (Misc queries) | |||
about fractions | Excel Discussion (Misc queries) | |||
Fractions | Excel Discussion (Misc queries) |