Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
function question
fDate fa fb fDat1 fDat2 fStock
2006-05-07 kk a 10 0 0 2006-05-18 kk G283 6 0 6 2006-05-14 kk a 9 0 9 2006-05-18 mm G274 9 1 8 2006-05-18 kk a 1 0 1 2006-05-18 hh G278 1 0 1 2006-05-18 pp m 2 0 2 2006-05-18 aa x 5 2 3 2006-05-19 mm G274 9 7 2 i want to make fStock field using excel worksheet function in the upper data *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
function question
One way:
Assuming fStock is column F: F1: =D1-E1 copy down. In article , x taol wrote: fDate fa fb fDat1 fDat2 fStock 2006-05-07 kk a 10 0 0 2006-05-18 kk G283 6 0 6 2006-05-14 kk a 9 0 9 2006-05-18 mm G274 9 1 8 2006-05-18 kk a 1 0 1 2006-05-18 hh G278 1 0 1 2006-05-18 pp m 2 0 2 2006-05-18 aa x 5 2 3 2006-05-19 mm G274 9 7 2 i want to make fStock field using excel worksheet function in the upper data *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF function question | Excel Worksheet Functions | |||
If Function Question | Excel Discussion (Misc queries) | |||
Function Question | Setting up and Configuration of Excel | |||
Function question | Excel Worksheet Functions | |||
Question Regarding Name Function | Excel Programming |