formulas

B

Bob Phillips

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

--
HTH

Bob

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

Bob Phillips

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)
 
M

mr bloby

many thanks

Bob Phillips said:
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)
 
Top