creating a formula

B

bugsy malone

i am relatively new to using computors and i was wondering if i can create a formula to work out what is left from a total if where the total is constant for instance hours in the day =24 (b9) and some of the hours are used e.g. eating 1 hour (b3) sleeping 7 hours (b4) using p.c. 3 hours (b5) watching t.v. 2 hours (b6) work 8 hours (b7) is there an equation i can use to automatically fill in misc. (b8)
 
A

Andy B

bugsy

In b8 type:

=B9-SUM(B3:B7)

Andy.

bugsy malone said:
i am relatively new to using computors and i was wondering if i can create
Click to expand...
a formula to work out what is left from a total if where the total is
constant for instance hours in the day =24 (b9) and some of the hours are
used e.g. eating 1 hour (b3) sleeping 7 hours (b4) using p.c. 3 hours (b5)
watching t.v. 2 hours (b6) work 8 hours (b7) is there an equation i can use
to automatically fill in misc. (b8)
 
P

Paul

bugsy malone said:
i am relatively new to using computors and i was wondering if i can create
Click to expand...
a formula to work out what is left from a total if where the total is
constant for instance hours in the day =24 (b9) and some of the hours are
used e.g. eating 1 hour (b3) sleeping 7 hours (b4) using p.c. 3 hours (b5)
watching t.v. 2 hours (b6) work 8 hours (b7) is there an equation i can use
to automatically fill in misc. (b8)

=B9-SUM(B3:B7)
 
P

Peo Sjoblom

One way

=MAX(0,B9-SUM(B3:B7))



--

Regards,

Peo Sjoblom


bugsy malone said:
i am relatively new to using computors and i was wondering if i can create
Click to expand...
a formula to work out what is left from a total if where the total is
constant for instance hours in the day =24 (b9) and some of the hours are
used e.g. eating 1 hour (b3) sleeping 7 hours (b4) using p.c. 3 hours (b5)
watching t.v. 2 hours (b6) work 8 hours (b7) is there an equation i can use
to automatically fill in misc. (b8)
 
Top