creating a formula

[Guest]

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)

 

[Andy B]

bugsy

In b8 type:

=B9-SUM(B3:B7)

Andy.

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)

 

[Paul]

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)

=B9-SUM(B3:B7)

 

[Peo Sjoblom]

One way

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



--

Regards,

Peo Sjoblom

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)

 

[Guest]

thanx for the quick response people much appreciated