ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   function question (https://www.excelbanter.com/excel-programming/367470-function-question.html)

x taol

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 ***

JE McGimpsey

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 ***



All times are GMT +1. The time now is 10:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com