| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| Formulas | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Linear Mode
