formulas
 

Hi can any one tell me the formula for a spread sheet for holidays

Days From To Type This Leave Remaining Section Head Reason Entered
22 HOL 2 22 PD
22 22
22 22
if i type hol in the col type
then the number of days in the col this leave
to deduct the 2 from the 22 in the col remaining
thanks in advance for any help

formulas
 

=IF(D2="HOL",F2-E2,"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mr bloby" wrote in message
...
Hi can any one tell me the formula for a spread sheet for holidays

Days From To Type This Leave Remaining Section Head Reason Entered
22 HOL 2 22 PD
22 22
22 22
if i type hol in the col type
then the number of days in the col this leave
to deduct the 2 from the 22 in the col remaining
thanks in advance for any help

formulas
 

Hi Bob thanks for the reply
new to this where do i put the formula ???

"Bob Phillips" wrote:

=IF(D2="HOL",F2-E2,"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mr bloby" wrote in message
...
Hi can any one tell me the formula for a spread sheet for holidays

Days From To Type This Leave Remaining Section Head Reason Entered
22 HOL 2 22 PD
22 22
22 22
if i type hol in the col type
then the number of days in the col this leave
to deduct the 2 from the 22 in the col remaining
thanks in advance for any help

formulas
 

in the appropriate cell on row 2, then copy it down

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mr bloby" wrote in message
...
Hi Bob thanks for the reply
new to this where do i put the formula ???

"Bob Phillips" wrote:

=IF(D2="HOL",F2-E2,"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"mr bloby" wrote in message
...
Hi can any one tell me the formula for a spread sheet for holidays

Days From To Type This Leave Remaining Section Head Reason Entered
22 HOL 2 22 PD
22 22
22 22
if i type hol in the col type
then the number of days in the col this leave
to deduct the 2 from the 22 in the col remaining
thanks in advance for any help

formulas
 

many thanks

"Bob Phillips" wrote:

in the appropriate cell on row 2, then copy it down

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mr bloby" wrote in message
...
Hi Bob thanks for the reply
new to this where do i put the formula ???

"Bob Phillips" wrote:

=IF(D2="HOL",F2-E2,"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"mr bloby" wrote in message
...
Hi can any one tell me the formula for a spread sheet for holidays

Days From To Type This Leave Remaining Section Head Reason Entered
22 HOL 2 22 PD
22 22
22 22
if i type hol in the col type
then the number of days in the col this leave
to deduct the 2 from the 22 in the col remaining
thanks in advance for any help